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?

Sure, just use the fully qualified network drive name. You can find it out by going to Windows Explorer. For instance if on the Windows Explorer navigation, you see

Data on 'HQShare\Public' (I:)

Then replace "I:\" in your code with "\\HQShare\Public\Data"

"Hargrove" wrote:

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?

Very cool. Thank you.

"MDW" wrote:

Sure, just use the fully qualified network drive name. You can find it out by going to Windows Explorer. For instance if on the Windows Explorer navigation, you see

Data on 'HQShare\Public' (I:)

Then replace "I:\" in your code with "\\HQShare\Public\Data"

"Hargrove" wrote:

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?