PDA

View Full Version : Auto Save excel file to another Computer on the network



mdasifiqbal
08-04-2017, 05:23 AM
Dear Friends

Need help to auto save excel file (copy and replace) from one computer to another computer on the network at interval of every 2 hours.

Thanks & Regards

Md Asif Iqbal

Kenneth Hobs
08-04-2017, 06:02 AM
In a BAT file:

Echo Off
Copy x1 x2 /Y

Where x1 is file to copy and x2 is the destination. /Y = Yes, overwrite if file exists.

Set the time to execute the BAT file, in Windows Scheduler.

mdmackillop
08-04-2017, 06:08 AM
Sub Test()
Call Saving
End Sub


Sub Saving()
ActiveWorkbook.SaveCopyAs ("D:\MyCopy\" & ActiveWorkbook.Name) 'Change to suit
Application.OnTime Now + TimeValue("02:00:00"), "Saving"
End Sub