I have a file structure like this:
\\Serversharedfolder\Folder1\Folder2\Workbook.xls
\\Serversharedfolder\Folder1\Folder2\Folder3\
I am trying to create a hyperlink for the pdfs inside Folder 3 from Workbook.xls. How do I specify relative path to achieve this?.When I Copy Folder 1 to a DVD I want the hyperlinks to work. Any help is appreciated.
Thanks