Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlinks and File Links
Hi
I have a workbook which has links to about a dozen other workbooks. These links need to change periodically as new versions become available. I do this manually via Edit Links Change source. (I haven't been able to do this using VBA as two levels of folders change and the filename has two elements which change) I have hyperlinks in the workbook which take me to the correct place in the linked files. Is there any way of matching the hyperlinks with the linked workbooks and having them update automatically as the workbook links change? Regards Phil Smith |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlinks and File Links
I don't think it's automatic, but this could make your life easier:
David McRitchie has some code that you can use to change the hyperlinks: http://www.mvps.org/dmcritchie/excel/buildtoc.htm look for: Fix Hyperlinks (#FixHyperlinks) If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm ==== You may want to start using the =hyperlink() worksheet formula. Then you'll be able to do simple Edit|Replaces to point at a new location. Philip J Smith wrote: Hi I have a workbook which has links to about a dozen other workbooks. These links need to change periodically as new versions become available. I do this manually via Edit Links Change source. (I haven't been able to do this using VBA as two levels of folders change and the filename has two elements which change) I have hyperlinks in the workbook which take me to the correct place in the linked files. Is there any way of matching the hyperlinks with the linked workbooks and having them update automatically as the workbook links change? Regards Phil Smith -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinks - change destination to over 2000 links!!!! | Excel Worksheet Functions | |||
Hot Links or Hyperlinks | New Users to Excel | |||
Create hyperlinks from external links | Excel Programming | |||
links to hyperlinks not working | Links and Linking in Excel | |||
Hyperlinks - Move file to local drive, all links break | Excel Discussion (Misc queries) |