dtms1
08-26-2012, 02:13 PM
Hi, so I have an excel file that I created a button that is linked to a hyperlink so that when you press the button a .docx file opens up.
However the way I have the hyperlink is set, is that it has to have an exact file path.
For example "C:\etc\etc\.docx"
But I would like to put these files onto a flash drive and with every computer the drive letter changes. Is there a way where I can go around this if the word files are ALWAYS in the same folder as the excel file?
for example if my excel file is in a random flash drive letter shown below
X:\folder\excel.xls
my word files will always be in the same directory if not in a subfolder
X:\folder\subfolder\word.docx
Is there a fix for this or a VBA code that can work around changing drive letters?
thanks
However the way I have the hyperlink is set, is that it has to have an exact file path.
For example "C:\etc\etc\.docx"
But I would like to put these files onto a flash drive and with every computer the drive letter changes. Is there a way where I can go around this if the word files are ALWAYS in the same folder as the excel file?
for example if my excel file is in a random flash drive letter shown below
X:\folder\excel.xls
my word files will always be in the same directory if not in a subfolder
X:\folder\subfolder\word.docx
Is there a fix for this or a VBA code that can work around changing drive letters?
thanks