Hi All, looking for a bit of advise on how to automatically run a macro daily.
I know that i can use:Sub auto_open() but i will need to access the file throughout the day and don't want the macro running every time I open the workbook.
I have read online that I could use the task scheduler could anyone help me set this up ?
here are the details of the workbook:
file path: C:\Users\admin\Desktop\Book1.xlsm
the macro I want to call is in a module called "test" and the sub is "Public Sub test()"
this workbook is updated daily I need to run the macro automatically every day at 5am.
What the macro does is it copies the new data and opens another workbook and pastes it to the correct place.
If anymore info is needed please ask.
Thanks
I know that i can use:Sub auto_open() but i will need to access the file throughout the day and don't want the macro running every time I open the workbook.
I have read online that I could use the task scheduler could anyone help me set this up ?
here are the details of the workbook:
file path: C:\Users\admin\Desktop\Book1.xlsm
the macro I want to call is in a module called "test" and the sub is "Public Sub test()"
this workbook is updated daily I need to run the macro automatically every day at 5am.
What the macro does is it copies the new data and opens another workbook and pastes it to the correct place.
If anymore info is needed please ask.
Thanks
