If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Linking to a file in another program
I have a powerpoint presentation template that links to an excel spreadsheet
template. The program works great, except when I change the file names from the Template name to something else, the Links still refer to the excel template file, rather than the file with all the data that has been renamed. How can I get the links to update to the new named file without clicking EDIT, LINK and then updating each link, one by one, to the new file? |
#2
|
|||
|
|||
Linking to a file in another program
In article , Teresa! wrote:
I have a powerpoint presentation template that links to an excel spreadsheet template. The program works great, except when I change the file names from the Template name to something else, the Links still refer to the excel template file, rather than the file with all the data that has been renamed. How can I get the links to update to the new named file without clicking EDIT, LINK and then updating each link, one by one, to the new file? Have a look here ... Search and Replace for Hyperlinks http://www.pptfaq.com/FAQ00773.htm ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ |
#3
|
|||
|
|||
Linking to a file in another program
Thank you Steve, that was very helpful. However, I am now getting an error
message when I run this macro. Have you used this macro before? If so, would you mind helping me figure out what i did wrong? thanks. "Steve Rindsberg" wrote: In article , Teresa! wrote: I have a powerpoint presentation template that links to an excel spreadsheet template. The program works great, except when I change the file names from the Template name to something else, the Links still refer to the excel template file, rather than the file with all the data that has been renamed. How can I get the links to update to the new named file without clicking EDIT, LINK and then updating each link, one by one, to the new file? Have a look here ... Search and Replace for Hyperlinks http://www.pptfaq.com/FAQ00773.htm ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ |
#4
|
|||
|
|||
Linking to a file in another program
In article , Teresa! wrote:
Thank you Steve, that was very helpful. However, I am now getting an error message when I run this macro. Have you used this macro before? On my own test files, yes, but everybody's situation's a bit different. You may have hit something it's not ready to cope with. If so, would you mind helping me figure out what i did wrong? thanks. Well, it might not be you; could be the macro y'know. :-) Let's see if we can't figure out what's up. First, I'll need to know the exact text of the error message. Hint: when it appears again, press Ctrl+Shift+C to copy the text. Also, tell me what the current path is and what you're entering to replace it with. "Steve Rindsberg" wrote: In article , Teresa! wrote: I have a powerpoint presentation template that links to an excel spreadsheet template. The program works great, except when I change the file names from the Template name to something else, the Links still refer to the excel template file, rather than the file with all the data that has been renamed. How can I get the links to update to the new named file without clicking EDIT, LINK and then updating each link, one by one, to the new file? Have a look here ... Search and Replace for Hyperlinks http://www.pptfaq.com/FAQ00773.htm ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ |
Thread Tools | |
Display Modes | |
|
|