I'd like to record a hyperlink or macro to open specified files. My problem is that these are housed on a shared drive so the file pathname may be I:\Exldata..., M:\Exldata..., or O:\Exldata.... (the remainder of the file path name is the same)

Is there a way?