Macro to Copy Workbook from One Drive to another at a Specific Time

Hi,

Everyday I need to copy a sheet which is updated by users and saved a Public Drive and I need to copy into my Personal Drive.This is done at a specific time which is at 1.PM.

Is there a macro which would copy sheet from Public Drive to my Personal Drive at 1PM everyday, I might be loged-in or loged-off from PC.


Thanks

Hi,

Can someone help me with this or else I will mark as solved.

you can schedule this in "Task Scheduler" in windows

write small vbscript to copy file and schedule it

Thank you Mohanvijay for your help. Sorry but I am not aware of vbscript.

Can you please suggest vbscript code for the below code which I used to copy the sheet. And also can you suggest how can I learn vbscript.

Private Sub Copy_sheet()

FileCopy Source:="D:\Ashish\VBA\Practice\Scheduler\Copysheet.xlsm", Destination:="D:\Ashish\VBA\Copysheet.xlsm"

End Sub

vbscript is lightweghit language of vba so if you know vba then you also know vbscript

vbscript files come with extension .vbs


FileCopy Source:="D:\Ashish\VBA\Practice\Scheduler\Copysheet.xlsm", Destination:="D:\Ashish\VBA\Copysheet.xlsm"

copy the above your code and paste it into notepad and save as with .vbs extension
and schedule it

when I schedule a task with your instructions, it is just opening the .vbs file and not running the code in it or copying the excel file.

I guess in the Actions field of create task I selected "Start a Programm" thats why it is opening the file, however there are only two other options "Send an e-mail", "Display a Message".

I might be wrong, can you please suggest. Thank you.