I am using Excel 2003
I use the next method to open a file located in the same folder of the current xls file
right click, hyperlink, choose Existing File or Webpage, choose desired file
but I want to open a file in a folder relative to where the current file is located, so when they are moved to another location, the link can work.
I use the next method to open a file located in the same folder of the current xls file
right click, hyperlink, choose Existing File or Webpage, choose desired file
but I want to open a file in a folder relative to where the current file is located, so when they are moved to another location, the link can work.