Using Network paths

[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

 

[Tom Ogilvy]

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).

 

[lothario]

Have you checked the Read/Write permissions on the mapped network drive

 

[Bob Phillips]

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)

 

[Guest]

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