Using Network paths

  • Thread starter Thread starter Rudolphs
  • Start date Start date
R

Rudolphs

Hello

Ive got a macro in my workbook which saves the file to a network path.
I have mapped the remote path onto G:

Using "G:\savedirectory\filename.xls" does'nt seem to work... Is there
something Im missing?
Can I use the remote IP address instead?

Thanks
 
if you actually have mapped the drive to the letter G and you have a
directory below the root named savedirectory, there is not reason you
shouldn't be able to use

G:\savdirectory\filename.xls

how are you trying to use it (with what command).
 
Rudolphs,

I also failed to write using a mapped drive letter, but it worked okay with
the UNC path.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Rudolphs, i have some similar macro that is directed to
import files from a shared g drive. you should right
click on the excel file, select the properties and verify
the path. u can even copy and paste the correct path from
the properties
vic
 
Back
Top