bugarin1010
Board Regular
- Joined
- Jan 28, 2008
- Messages
- 59
Hi forum,
I'm using XL and PowerPoint 2007. I've been able to create charts in PowerPoint that are linked to a specific XL file that has all of the data for multiple PowerPoint charts.
My goal is to have this XL file as the only companion file a user needs to update so that any changes he/she makes here will automatically propagate to the PowerPoint file.
Unfortunately, my issue is that when I email the PowerPoint and XL documents together, the PowerPoint file will retain the link to the XL file in my specific hard drive and so, a new user has to go edit the links manually to point to the new XL file. I would rather the PowerPoint file not care where the XL was originally saved and instead, only look for the XL file in the same directory as the PowerPoint file.
Is there an easy way for this to be done automatically? Can this be done in VBA?
Thanks for any thoughts!
I'm using XL and PowerPoint 2007. I've been able to create charts in PowerPoint that are linked to a specific XL file that has all of the data for multiple PowerPoint charts.
My goal is to have this XL file as the only companion file a user needs to update so that any changes he/she makes here will automatically propagate to the PowerPoint file.
Unfortunately, my issue is that when I email the PowerPoint and XL documents together, the PowerPoint file will retain the link to the XL file in my specific hard drive and so, a new user has to go edit the links manually to point to the new XL file. I would rather the PowerPoint file not care where the XL was originally saved and instead, only look for the XL file in the same directory as the PowerPoint file.
Is there an easy way for this to be done automatically? Can this be done in VBA?
Thanks for any thoughts!
