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

Private Sub Workbook_BeforeClose(Cancel As Boolean)

With Range("A100")
 .Value = Date
 .NumberFormat = "mm/dd/yy"
 End With

End Sub

For the workbook open event

Private Sub Workbook_Open()

Dim lastdate As Date
Dim todaysdate As Date
Dim thisday As Integer
Dim lastday As Integer
Dim noofdays As Integer


lastdate = Range("A100")
todaysdate = Date
thisday = Day(todaysdate)
lastday = Day(lastdate)
noofdays = todaysdate - lastdate


If noofdays > 0 Then
        
    Dim i As Long
    For i = 1 To noofdays * 2
       autoincrement
    Next
    


Else


End If


End Sub

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