By default, unspecified paths to hyperlink destination files are in relation to the location of the active workbook. Use the following procedure when you want to set a different default path. Each time that you create a hyperlink to a file in that location, you have to specify only the file name, not the path, in the Insert Hyperlink dialog box.
1. Click File > Info.
2. Click the Properties arrow, and then click Advanced Properties.
3. Click the Summary tab.
In the Hyperlink base box, type the path that you want to use.
The above description documents a manual procedure; I'm hoping that someone can tell me how to accomplish the same task in VBA macro code.
Thanks in advance for the support and assistance.
Bookmarks