YetAnotherForum
Welcome Guest Search | Active Topics | Log In | Register

Periodic update to embeded .ppt object in a display. Options · View
ThePIman
#1 Posted : Tuesday, February 08, 2011 12:22:54 PM
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?

.
Sponsor  
 

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.
RJK Solutions
#2 Posted : Friday, February 11, 2011 1:49:09 PM
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
ThePIman
#3 Posted : Friday, March 18, 2011 8:44:20 AM
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 Cursing
Cheers

.
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.