(VBA in PPt file) Updating links on opening ppt file

[pm]

hello,

i have presentation with almost 100 links..

due to fact that i open it from VBA macro located in excel file
i'd like to update automaticly all links on opening ppt file,
because when opened from VBA code (in excel) no information
about links appears...

rgs

 

[pm]

due to fact that i open it from VBA macro located in excel file
i'd like to update automaticly all links on opening ppt file,
because when opened from VBA code (in excel) no information
about links appears...

i find private sub:

Private Sub App_PresentationOpen(ByVal Pres As Presentation)

ActivePresentation.UpdateLinks

End Sub

but nothing happen when:
- click 'no' when asking about updating links when file is opening
- file is opened from excel file

does anyone has idea how can i update links anytime i open
presentation??

 

[Tushar Mehta]

To use an application event procedure you must create a 'withevents'
variable and set it to the application. See PP VBA help for 'Using
Events with the Application Object' (w/o the quotes).

If you want the code to run for every presentation, you would have to
put it in an add-in. See
Running Code Automatically when a PowerPoint Add-in Is Loaded or
Unloaded
http://msdn.microsoft.com/library/default.asp?url=/library/en-
us/modcore/html/deovrrunningcodeautomaticallywhenpowerpointaddinisloade
dorunloaded.asp


--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions