|
|
Rank: Newbie
Groups: Member
Joined: 5/19/2010
Posts: 8
Location: hanoi
|
i don't know how to auto update pi value in excel. but not use method Ontime of excel.can you help me .
thank!
|
|
|
|
|
OSIsoft vCampus is a subscription-based, online offering that consists of providing everything people need to develop applications on the PI System. We invite you to take a "tour" of the OSIsoft Virtual Campus - also feel free to consult the FAQ or contact OSIsoft vCampus for more details.
|
|
|
Rank: Administration
Groups: Administration
Joined: 6/20/2008
Posts: 612
Location: Cheshire, United Kingdom.
|
What version of PI Datalink are you using? Version 4.x has an auto updating timer built in to the datalink add in - is it an option for you to upgrade? Principal Consultant
Real-Time Data Management @ Wipro Technologies
|
|
|
Rank: Newbie
Groups: Member
Joined: 5/19/2010
Posts: 8
Location: hanoi
|
oh my version version of my PI Datalink i use is 2.1 .  . so have any way for me to do that with my PI Datalink ?
|
|
|
Rank: Administration
Groups: Administration
Joined: 6/20/2008
Posts: 612
Location: Cheshire, United Kingdom.
|
Version 2.1, I will need to blow the dust off my manuals for that version  What version of Excel are you working with? Principal Consultant
Real-Time Data Management @ Wipro Technologies
|
|
|
Rank: Member
Groups: Member
Joined: 7/16/2009
Posts: 12
Location: saudi arabia
|
With the help of a friend who is a programmer, we were able to develop an excel sheet that refreshes pi tags automatically. See the attached excel file for details. http://hotfile.com/dl/48...5/Plant_Overview_Final_(2).xlsm.html
|
|
|
Rank: Newbie
Groups: Member
Joined: 6/23/2010
Posts: 8
|
I'm also having trouble getting PI data tp update in excel. I have datalink version 4.1.1 and excel 2007. I've set the datalink to update every 10 seconds and i also have a macro running application.calculatefull, but the PI data just shows 'Resize to Show All Values' and when i right-click and select 'recalculate function' it updates. I saw menion of a VB function 'dlresize' in another post. Can some give an example of how this is sued within a macro.
Thanks. Mark.
|
|
|
Rank: Newbie
Groups: Member
Joined: 6/23/2010
Posts: 8
|
managed to get this working, for info: Insert a VBA reference to PIDLDialogs.xla Private AutoUpdate() Sheet1.Range("C8 8").Call dlresize End Sub
|
|
|
Rank: Administration
Groups: Administration
Joined: 6/20/2008
Posts: 612
Location: Cheshire, United Kingdom.
|
Glad you got it working, I would have suggested something along the same lines. The dlresize method is not well documented by OSI but works perfectly and I was suggested it by OSI TechSupport back in the days when v3 was first released so it looks like it is staying put for now. Principal Consultant
Real-Time Data Management @ Wipro Technologies
|
|
|
Rank: Newbie
Groups: Member
Joined: 7/1/2011
Posts: 5
Location: USA
|
|
|
|
|
Guest
|
