Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

share|improve this question
add comment

5 Answers

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. –  Diago Jul 28 '09 at 22:13
add comment

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
add comment

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
add comment

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
add comment

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

share|improve this answer
add comment

Your Answer

 
discard

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.