Wonderware Historian

azlan270690

Member
Join Date
Sep 2014
Location
Perth
Posts
1
Hi all,
Hoping I can get some help. We use wonderware historian at work and I'm hoping to setup a spreadsheet using VBA that can grab historical plant data from the database and return the values to the spreadsheet at the click of a button. I am also hoping for it to perform some calculations and return some graphs once I get the hang of things.

Problem is I'm not entirely familiar with how to get VBA to retrieve data from our database using wonderware historian. We have similar spreadsheets for Pi currently, however the setup with wonderware historian is completely different. Hoping someone out there may have done this before and can point me in the right direction. Essentially I want to create an automated spreadsheet that can retrieve historical data at the click of a button (given some set dates).
Cheers,
Kris
 

Similar Topics

Hi, We are setting up an Aveva Plant SCADA node with the intention to connect it to a Wonderware Historian node. Everywhere I look online I see...
Replies
1
Views
117
So I'm trying to make a tag I created in WonderWare Historian display the correct tag values on the inTouch client but it is currently showing...
Replies
12
Views
1,467
Hello there, Our plant is running Wonderware Historian on a Virtual Server and every few days I'm losing comms to my PLCs. Usually I can simply...
Replies
3
Views
2,027
Hi all, I found some interesting issue from my Wonderware environment. At my Trend table option, if i select "both", the Trend table is not...
Replies
2
Views
3,628
Hello, I want to monitor Wonderware historian's heartbeat and trigger a fault if Historian is not communicating /offline in PLC. Currently my...
Replies
0
Views
776
Back
Top Bottom