Automatically run macro

[Bobhelge]

Hey,

Is there a way to automatically run a macro once a week (let's say friday at 12:00), but if the workbook is closed at that time run it the next time its opened?

I don't want it to run everytime on opening. Only if the friday schedule is missed.

Thank

 

[JazzSP8]

Hi

You'll want to be searching for the Application.OnTime event, you should find something that will be able to help you out there; there's plenty of examples of it's uses on this Forum

As for the running of the macro if it misses the Friday I'd suggest using a cell as a holder for the date of the last time it was run, if it's longer than a 7 day time difference then launch your macro, if not just open the book as normal.

Hopefully that will point you in the right direction.

 

[Andrew Poulsom]

You could also use Windows Scheduler - example here:

http://forums.techguy.org/business-applications/636786-set-email-reminder-base-excel.html

 

[Bobhelge]

Thank you very much Jazz! I think your last suggestion might work! :D

 

[Bobhelge]

You could also use Windows Scheduler - example here:

http://forums.techguy.org/business-applications/636786-set-email-reminder-base-excel.html

Thank you