Macro: Hyperlink shown as ...."OPEN file"

[Snoopy]

Hey guys
My macro lists my files and generates hyperlinks to the files in a
given folder ... but ...
the celle-values in this list is the same as the filename incl path
and thus very long expression.
I want to keep the hyperlink reference, but just have a common celle-
value: "Open" instead.

Example:
Cell A2 value = Y:\ORDRER 2007\01007 Natoil_Rig 4 Drilling and Mud
Module\Document Control\Documents & Drawings from Client\Documents\R -
Documents\V1265-R-FD-001_Rev_0_-_TD7124-07-
WP-001_rev_01_WEIGHING_PROCEDURE.pdf
This expression I just want to show as "OPEN file"

NB! The files could be of any application so I dont think file.open
command will work.

Best regards
Snoopy

 

[Pete_UK]

Try this in B2:

=HYPERLINK(A2,"OPEN file")

Hope this helps.

Pete

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

Thanks a lot Pete! - Fabulous!! Perfect!!
Best Regards
Snoopy