Run macro x no. of times if file closed for x no. of days.

I have a macro that runs automatically at a certain time each day. If the workbook is closed it obviously will not run.

Is there a way to get it to run for example-if the workbook was closed for x number of days, the macro runs x number of times on Workbook_Open?

I know I can use the task manager to run excel but would like a solution if the computer gets shut off.

Thanks

Try before close to enter a date and time in a cell.
Then use workbook. open to determen the difference between the date in the cell and todays date (date when you open the file again).
When you get a number then set it so it runs the macro the number times

So this will have a macro save a date before close and check before open
If the date is the same as today (when you open the workbook back) then just exit sub

Thanks will try that and update after a few days testing

Ok Good Luck!

That has worked. Thanks.

It would be a good idia, if you could paste the code you used in here if some else will be looking for a simular answer

Good idea

For the workbook close event

Please Login or Register  to view this content.

For the workbook open event

Please Login or Register  to view this content.

If you see anything wrong here let me know but it seems to work okay. I have it running twice for each day hence the *2 bit

Thanks
I bet it will be useful