Fellow Forum Members,
What needs to be changed to this formula:
=HYPERLINK("C:\Root\4x\trades\2009 forward\01 USD-CAD\"&TEXT($A2,"mm-dd-yy")&" "&TEXT($B2,"hh mm")&".pdf")
So that the path shown below is hidden in all of my hyperlinks:
C:\Root\4x\trades\2009 forward\01 USD-CAD
I want the hyperlink to only show the PDF filename. As shown below:
02-12-09 10 00.PDF
The attached Excel file will give you a better idea.
In the past I have seen hyperlinks where the PATH is hiding. How is this done? ANy help will be greatly appreciated. THanks.
Bookmarks