I have a PowerPoint file (Office 2007) that has Linked Object on each slide to various excel files. I need to move the Excel source files to a different folder location. Currently they sit in "\\serverXY\DataFiles" and I need to move them to "\\serverAQ\DataFiles".
Since I have doesn't of slides, instead of updating these links manual, I'm wondering if there is a way to update all the links programmaticly through VBA? Here's the other thing. I don't need to update the WHOLE link, only the portion of the link that starts with "\\serverXY\DataFiles" should be changed to "\\serverAQ\DataFiles".
Any ideas? Thanks!