View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Copying files ...Network to Network

if you really mean network to network, probably using ftp.

If you mean from one network drive to another in your local network,
probably the copyfile command using the scripting runtime.

or maybe even the builtin vba filecopy command.

Regards,
Tom Ogilvy




"Eric" wrote in message
...
Hi There,

Can abody give me some tips on how to copy an excel files
from network to network using macro (vba) commands.

Appreciate anyone's help.

Thanks
Eric