Shared Drive/Macro or Hyperlink

H

Hargrove

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?
 
M

MDW

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"
 
H

Hargrove

Very cool. Thank you.

MDW said:
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"
Click to expand...
 
Top