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.
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.