Hi,
Not sure if Powerpoint VBA is the same as in Excel so please just close this thread if I'm in the wrong.
Essentially I have inserted a linked worksheet object in to a Powerpoint slide and I would like this worksheet to automatically update each time this particular slide is viewed. The goal is to be able to view it on a TV with no user interaction then another department can update the Excel file separately.
Currently I have the Edit links set to manual refresh otherwise with automatic there is a pop-up on startup to accept the automatic update links setting.
This is what I found online not sure how far wrong it is (it doesn't work either way...)
Any help would be much appreciated, I have been researching this for hours!
Not sure if Powerpoint VBA is the same as in Excel so please just close this thread if I'm in the wrong.
Essentially I have inserted a linked worksheet object in to a Powerpoint slide and I would like this worksheet to automatically update each time this particular slide is viewed. The goal is to be able to view it on a TV with no user interaction then another department can update the Excel file separately.
Currently I have the Edit links set to manual refresh otherwise with automatic there is a pop-up on startup to accept the automatic update links setting.
This is what I found online not sure how far wrong it is (it doesn't work either way...)
Code:
Sub refresh() If SSW.View.CurrentShowPosition = 1 Then
ActivePresentation.UpdateLinks
End SubAny help would be much appreciated, I have been researching this for hours!
