PDA

View Full Version : Dynamic hyperlink to folder Path problems


Lanky
10-26-2016, 04:32 AM
A little help please.
I am trying to create a dynamic hyperlink to the folder path below. The file name is in C195 and the hyperlink is in D195. Right now I am getting the file path not found error but I know the file is in the correct location. What have i done wrong in the string below? Comma or "" wrong.?

=HYPERLINK("P:\K Platform\Assembly\320B FILE START\01 Vehicle Development\06 TIS TRACKING\TIS folder\" & C195,"LINK")

Thanks for all the replies in advance.
Kenneth Hobs
10-26-2016, 04:59 AM
Welcome to the forum!

Obviously, if c195 is a filename and not a folder name, it must a filename extension. e.g. ken <> ken.pdf
Lanky
10-26-2016, 05:03 AM
Welcome to the forum!

Obviously, if c195 is a filename and not a folder name, it must a filename extension. e.g. ken <> ken.pdf

Thanks Ken, C195 is the file name in \TIS folder\ I need it to open the folder where the user will see the multiple pages of PDFs.

Thanks
Kenneth Hobs
10-26-2016, 06:27 AM
Obviously, if you want to open a folder, you don't want to set a filename.
=HYPERLINK("P:\K Platform\Assembly\320B FILE START\01 Vehicle Development\06 TIS TRACKING\TIS folder\","LINK")
Lanky
10-26-2016, 06:43 AM
Obviously, if you want to open a folder, you don't want to set a filename.
=HYPERLINK("P:\K Platform\Assembly\320B FILE START\01 Vehicle Development\06 TIS TRACKING\TIS folder\","LINK")

Thanks Ken, I figured it out.
=HYPERLINK("P:\K Platform\Assembly\320B FILE START\01 Vehicle Development\06 TIS TRACKING\TIS folder\" & C12,"LINK") I had an extra " after declaring the cell to reference. My down fall is always with "" and ().