I've written the following VBA Code to open a Powerpoint Presentation with the updated Excel cells that are linked. The button I've created, DOES open the Powerpoint Presentation, but it doesn't give me the opportunity to update the new info that's linked. When I open Powerpoint, selecting INFO, that Update Links, it only updates ONE link...not all of them. (There's about a dozen links that need to be updated upon opening. Is there anything that I can add to this code below that will, not only open the Powerpoint Presentation, but ALSO UPDATE ALL THE LINKS upon opening? PLEASE AND THANKS!
Sub OpenPowerPoint()
Dim MyPPT As Object
Set MyPPT = CreateObject("Powerpoint.application")
MyPPT.Visible = True
MyPPT.presentations.Open "C:\Users\Mike\Desktop\Club Newport Presentations\Part 2-(Both) Destinations Club Newport Presentation.pptm"
End Sub
Sub OpenPowerPoint()
Dim MyPPT As Object
Set MyPPT = CreateObject("Powerpoint.application")
MyPPT.Visible = True
MyPPT.presentations.Open "C:\Users\Mike\Desktop\Club Newport Presentations\Part 2-(Both) Destinations Club Newport Presentation.pptm"
End Sub