Hi -
I have a macro that opens a powerpoint presentation and updates linked graphs. I was able to figure out how to get the VBA to save and close the presentation, but because this is a weekly report, I was hoping to be able to save a new copy under a different name. I've tried a number of different solutions but to no avail. I continue to get an error message "SaveAs: PowerPoint encountered an error when attempting to save." This is my code I tried. Any suggestions? Thanks!
I have a macro that opens a powerpoint presentation and updates linked graphs. I was able to figure out how to get the VBA to save and close the presentation, but because this is a weekly report, I was hoping to be able to save a new copy under a different name. I've tried a number of different solutions but to no avail. I continue to get an error message "SaveAs: PowerPoint encountered an error when attempting to save." This is my code I tried. Any suggestions? Thanks!
Code:
sFile = "Operations Weekly Deck - " & Date
sFilePath = "S:\\Reporting\US\Weekly Reporting Decks\Operations Weekly Deck\" & sFile & ".pptx"
pPreso.SaveAs sFilePath