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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.