Data from a network location

[Chris]

Hi all...

I am importing data from one workbook to another. I have it owrking fine on
a local location c:\ to c:\ but it will need to work across network
locations (possible mapped netwrk drives). Would really appreciate some
tips.

Chris

 

[Joel]

There are two forms of the filename for excel

1) "c:\temp\abc.xls" - You can map remote directories by going into Window
Explorer - Tools - Map Network Drive to H: and using "H:\temp\abc.xls"

2) Use the Network Name "\\mydrive\myname\mysubdirectory\abc.xls". Notice
you don't put http: or file: - excel just wants the path name.