I think I'll go with post # 6 and #8
say $a$1 contains the path and sub folders then a2 is your file name
or
say $a$1 contains the path with the formula in post # 8 then a2 is your sub folders and file name

=hyperlink("File:////"&$a$1&a2,"Click")

this way only cell A! will be changed according to the drive letter of the computer...