Automatically updating linked slides while in slideshow

  • Thread starter Thread starter USAF Sgt Mark
  • Start date Start date
U

USAF Sgt Mark

I run a maintence shop and I have a slideshow linked to excel workbooks
showing a constant status of all equipment in shop. I need to have poerpoint
update the slides automatically when the host file is updated with out
showing the popup to click update links and enable macros like the add-in
update links does. This slideshow will be running 24 hours a day 7 days a
week, the program will not be turned on and off so it litterally needs to
update when the host excel file in the server gets updated. Any way to make
this happene wether it be through VBA codes or through add-ins (mind you I
looked at update links and liveupdate and neither worked to my needed specs).
I should let you know the excel sheet powerpoint is linked to is also linked
to another excel sheet, so everytime I open PPT I have to update links in
powerpoint for each slide plus update links in the host file just to open the
program. If I do find a way to update links in slide show it has to be
without me clicking yes (update) like I have to in start up. Thank you for
any help.
 
I have used some help from other previous posts and have this VBA code:

Sub Update()
Dim oSl As Slide
Dim oSh As Shape
For Each oSl In ActivePresentation.Slides

For Each oSh In oSl.Shapes
If oSh.Type = msoLinkedOLEObject Then
oSh.LinkFormat.Update
Debug.Print "Updated: " & oSh.Name


End If
Next
Next

' now go to second slide
SlideShowWindows(1).View.GotoSlide (2)

' tell PPT to ignore any changes we made
' don't offer to save the presentation
ActivePresentation.Saved = True

End Sub

This works but I have two problems: Problem one Since these networked
connected laptops are not manned no one can click start show action but that
has been set up in the first slide. Problem two since these slides are linked
to an macros excel sheet that is linked to another excel sheet when it does
update I have to enable macros and update the excel spreadsheet links for
each slide in the show (average 20 slides). Is there any way to have the
action button already activated on each loop of the slideshow (without a
mouse click) and is there a way to have it update the links without opening
up the source file to update it's links too. The key is I can not click
anywhere. Please help!
 
Back
Top