Thread: Copying files ...Network to Network
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob Bovey Rob Bovey is offline
external usenet poster
  
Posts: 811
Default Copying files ...Network to Network
"Eric" wrote in message
...
Can abody give me some tips on how to copy an excel files
from network to network using macro (vba) commands.

Hi Eric,

I'm not sure precisely what you mean by "network to network", but here's
an example of copying a file from one server share to another server share
on the same network:

FileCopy "\\SERVER1\ShareName\Book1.xls", _
"\\SERVER2\ShareName\Book1.xls"

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *



Reply With QuoteReply With Quote