jakemike16
New Member
- Joined
- Jul 11, 2017
- Messages
- 2
I have a PowerPoint presentation that is linked to an Excel sheet containing data that is refreshed monthly.
I have written a macro that will refresh the data in the excel sheet, but I'm struggling to automate the updating of the links in the PowerPoint.
When I open up the PowerPoint presentation I get a Microsoft Powerpoint security notice asking if i want to update the links.
I would like the macro to be able to open the PowerPoint presentation and automatically select "Update links" button.
Is there code out there that would make this possible.
Thank you so much for the help.
I have written a macro that will refresh the data in the excel sheet, but I'm struggling to automate the updating of the links in the PowerPoint.
When I open up the PowerPoint presentation I get a Microsoft Powerpoint security notice asking if i want to update the links.
I would like the macro to be able to open the PowerPoint presentation and automatically select "Update links" button.
Is there code out there that would make this possible.
Thank you so much for the help.