VBA needed to Update/ Change many linked excel charts in PowerPoint 2019 presentation. Change the entire path name including the Drive Letter

[mikeannetta]

I’ve seen a lot of examples of doing this, none that worked. I have a PPT presentation with over 200 linked charts to an excel file on my computer.

Current FULL Path: "C:\Users\”myname”\Documents\1-MyDocuments\1-Annetta\OT\SURVEYS\2019 Survey #2 SYMPTOMS & DIAGNOSES\NEW FILTERED CHARTS AND DATA LINKED SURVEY #2 ANALYSIS.XLSM"
I want to change the it so I can copy the Excel Sheet and The Presentation to a USB Jump Drive?
New Full Path Name example: T:\ NEW FILTERED CHARTS AND DATA LINKED SURVEY #2 ANALYSIS.XLSM"
I’ve copied the other VBA’s to the PowerPoint presentation and it did not work at all.
Any help would be appreciated. I can send the code(s) I’ve tried, but thought that might muddy the waters?

 

[Fluff]

Duplicate to: Excel and Power Point Chart Links - MS Office Professional Plus 2019

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.