My client asked me to generate a powerpoint report with many charts linked to an excel data file.
My problem is that though the presentation slides are static their data is dynamic.
I want to link the charts data to the excel file (where i can place my macro), but the problem is that on the client's pc, things will get mixed up since the excel file is linked to a specific path on my PC.
Is there a way to use relative path?
OLE links (like links to XLS data) cannot be relative.
In past versions of Office, if the linked source XLS wasn't found on the path the link pointed to, PPT would look for the file in the same directory as the PPT itself and if found there, would use it. MS seems to have "improved" that feature. It no longer works, near as I can tell.
You could conceivably put your files in a specific directory and create that same directory on the target PC, though.
Or if you can run code on the client end, supply a macro that looks for the files in the same directory as the PPT and resets the links to point to that directory.