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?
5 Answers
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"2
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\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.
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.
Another option is to use the Windows SyncToy 2.0 utility and then set a scheduled task along with it.
