|
|
Rank: Advanced Member Groups: Member
Joined: 5/14/2009 Posts: 35 Location: UK
|
We have a slideshow running 24/7 with various trend displays, but want to add a page from a PowerPoint presentation to a display which will update if there are any changes to the presentation. Our problem is that when you start the slideshow it opens the displays and will read the ppt but not refresh it. If the .ppt file is open on the PC then it will show the updates, but this file is updated by various people in the network so can't stay open. Any idea how to force a regular update on an embedded / linked file inside a display?
.
|
|
|
|
|
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: 617 Location: Cheshire, United Kingdom.
|
Hmmm, without testing this I guess you could try to re-open the powerpoint in VBA to see if that triggers a refresh. The Powerpoint presentation will be added as an OLEObject so you can get at the Presentation object and reload it, something like: Code: 'Add reference to Powerpoint Dim P As Presentation Set P = OLEObjects(1) ' Find the index of the Presentation OLEObject Call P.Application.Presentations.Open(P.Name) 'Re-open itself.
Principal Consultant Real-Time Data Management @ Wipro Technologies
|
|
|
Rank: Advanced Member Groups: Member
Joined: 5/14/2009 Posts: 35 Location: UK
|
Thanks for the code Rhys but we couldn't get it to work. After coming back to it we've hacked something together that monitors the update date on the file and then re-opens it if it changes. You'd have thought this would be simple request to solve, but we've had a nightmare Cheers .
|
|
|
|
Guest
|