I have a list of pdf files in a folder;
3_01877_400_015_REV_B5
3_01877_400_016_REV_B4
3_01877_400_017_REV_B2
3_01877_400_018_REV_B1
3_01877_400_019_REV_B2
I have a excel file setup to act as a directory for all these files. I use hyperlinks to bring the user from the excel file to the pdf files in question.
the problem is that the revision number B2, B4 etc. changes frequently. this then means that the hyperlink has to be changed.
is there any way that the hyperlink can be constructed to just reference the beginning of the file name, for instance;
"3_01877_400_016"
excluding the revision number at the end? as long as there is only one "3_01877_400_016" in that folder, the hyperlink should then always open the file.
Bookmarks