Refer to network drive using network name instead of a mapped letter (eg "G:\")

[Glory]

At my work, the people who set up the computers used a lot of different letters to map the network.

I've tried using the path " \\networkname\ " in place of a letter, with no luck.

Any ideas?

 

[cb711]

try file://network/

 

[Glory]

Literally "file", or is "file" replaced with something else?

For the rest of the path, do I revert to using backslashes?

" file://network/folder1\folder2\file.xls "?

 

[Glory]

Bump.

 

[Glory]

Bump.

 

[Scott Huish]

See here on how to use UNC:

http://www.mrexcel.com/forum/showthread.php?t=490853&highlight=fChDirUNC

 

[Glory]

Would you suggest that I loop through a series of possible letters to determine which has the network mapped to it?

The only thing is that there are several networks. It might not fail, but still not return the proper network. I guess I could go on error 1004 (or whatever the number is for an invalid path instead of an unfound file), but then I'm basically right back where I started.

 

[Scott Huish]

No, use the UNC naming convention instead, and don't worry about mapped drives:

fchDirUNC ("\\networkname\folder\")

 

[Glory]

...Excellent.

Thanks.

 

[Glory]

http://www.mrexcel.com/forum/showthread.php?t=490853
Cross-threading.