schedule a code to run once a week

[kosherboy]

Hello forum,
I found this code in a different forum where it is scheduled to run once a month:

Please Login or Register  to view this content.

i love this code because it stores the last run date in some inner library so that if the day was missed it will still run the next time the workbook is opened, but i don't know how to make this code run once a week. I can get it to run once a day because excel recognizes the code word "Day", but excel will not recognize the word "Week".
Any help on this would be greatly appreciated.

Thanks!

[LJMetzger]

Hi,

The date last run is stored in 'Custom Document Properties' in your file. Each Excel file has 'Built In' Document Properties and 'Custom' Document Properties.

To access 'Built In Document Properties':
Excel 2003: File > Properties > Summary
Excel 2010: File > Info > Properties > Advanced Properties > Summary


To access 'Custom Document Properties':
Excel 2003: File > Properties > Custom
Excel 2010: File > Info > Properties > Advanced Properties > Custom

Try the following modified version of your Macro:

Please Login or Register  to view this content.

Lewis

[kosherboy]

Hi Lewis,
Thanks for explaining to me how the code works, it's very much appreciated.
The code ran the first time and worked!, now all i have to do is wait a week and see if it runs a second time
It looks good so far.
Thank you again Lewis, all the best to you

[LJMetzger]

My pleasure to help and thanks for the rep points.

You can test the code without waiting a week. Go to the custom property and edit the date. If you change the date to March 2 it should not run. If you change the date to March 1 it should run.

You can temporarily comment out your macro if you don't want your macro to run again today.

[kosherboy]

Great idea!
It worked!
Thanks again.