Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 6 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"
share|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. – BinaryMisfit Jul 28 '09 at 22:13

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\
share|improve this answer

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.

share|improve this answer

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.

share|improve this answer

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

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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