Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying files ...Network to Network
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 * |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Navigating to Excel files over network slow, but not Word files | Excel Discussion (Misc queries) | |||
.XLB files and network | Excel Discussion (Misc queries) | |||
how can I syncronize excel files on a network? | Excel Discussion (Misc queries) | |||
can not save office2000 files with new name over network | Excel Discussion (Misc queries) | |||
Hyperlinks to network files | Excel Discussion (Misc queries) |