Scheduling a Macro.

[DaniExcel]

Hi All,

I have had a look and can't see that this has been answered before so hopefully someone can help.

I have written a Macro and it's working great. I now need to schedule it to run at 12:00, 14:00 and 16:00 each working day, automatically.

I will need the macro to open the file, run the macro I have already written and then close the file.

Thanks in advance for your help.

Dani.

oh ps, I am on Excel 2013 and VBA v7.0

 

[keaveneydan]

You can use the task scheduler on your machine to open the file....look in programs or google further how to do this...it's quite easy
Have to macro run automatically on opening the file ....Sub Workbook_Open ()
Then have your last action in the macro to be close and save.

 

[DaniExcel]

You can use the task scheduler on your machine to open the file....look in programs or google further how to do this...it's quite easy
Have to macro run automatically on opening the file ....Sub Workbook_Open ()
Then have your last action in the macro to be close and save.

Hi,

Thanks for your reply.

I am struggling to find anything that is making sense, I don't suppose you have alink?

Also, preferably, I don't want to have to open the workbook myself, just for it to open and run at the specified time. Is this possible?

Thank again,
Dani.

 

[keaveneydan]

Read this Starting excel file with task scheduler and you will be able to schedule your PC to open the file at specified times.

If you call your macro Sub Workbook_Open () it will run automatically when the file is opened

Put this piece of code at the end of your already writtn code and it will save and close the file
ActiveWorkbook.Close SaveChanges:=True

 

[DaniExcel]

Brilliant, got it!

Thanks so much. I was thinking that Scheduler was an Excel feature and so couldn't find it.

Thanks again!