Here is what I am after.

I have 2 PCs connected on a network and one of them prints out an excel spreadsheet every night to a specific folder. is it possible to use a batch script to copy that file to the other computer on the network at a certain time?

Thanks

link|improve this question

75% accept rate
feedback

5 Answers

up vote 5 down vote accepted

You can.

  • Create Batch File (Use UNC paths to copy - I recommend RoboCopy)
  • Create Scheduled Task to call batch file at certain time
robocopy C:\FolderName\ \\machinename\sharedfolder "filename.ext"
link|improve this answer
If you don't want to use robocopy you can also map a network drive for the remote destination and then just use copy. – jtb Jul 28 '09 at 22:08
@jtb - Agreed. Robocopy is faster however and supports resuming. The only reason I suggest it. Also it is more robust when using UNC. – Diago Jul 28 '09 at 22:13
feedback

Set up a scheduled task to run a program/batch file that executes a copy command.

A batch file to do that might look like

COPY \\server-name\path\to\file.dat C:\directory\new-location\
link|improve this answer
feedback

An alternative to a batch file / Windows scheduled task, is to use SyncBack (freeware) where you can create a profile to copy your Excel spreadsheet from the source machine to the target at a specific time.

link|improve this answer
feedback

You can save this in a .bat file. After that you can schedule it.

:: This is the backup 


set SourceDir=F:\XXX
set DestinyDir=I:\YYY


xcopy /e /v /y /I %SourceDir% %DestinyDir%

I never tested the time it takes, but it seems that xcopy is faster than the regular copy. Look what the commands do here.

link|improve this answer
feedback

Another option is to use the Windows SyncToy 2.0 utility and then set a scheduled task along with it.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.