open a file using the drive name rather than drive letter

[mikeymay]

I want to open a file on a drive that is labelled as 'G:' on my pc. This particular drive does not have the same drive label on other pc's so I was hoping to open the file using the drve name.

Is this possible? I have tried a few variation of the full path name of the file, but with no joy.

Thanks all

 

[onlyadrafter]

Hello,

I think you need to see IT, we had the same problem, instead of Z:\

we had to use

\\DRAW\OFFICE\CONTROL DOCUMENTS\

 

[Richard Schollar]

If you want to check what the UNC drive names are you can use the following code:

http://www.mrexcel.com/board2/viewtopic.php?p=1084550#1084550

Best regards

Richard

 

[mikeymay]

Thanks Richard that sub was bob on!!!!

Problem now sorted