How to run VBA event only once in a day?

[Mdarshadali2609]

I recorded a script to a macro file and called that specific macro using a VBA project (personal.xlsb). Every time any Excel is open (Workbook_open).

But now I only want to restrict that call to once a day. For example if the individual macro calls that specific macro once a day, then the event is postponed to the next day and the macro is not called upon opening any Excel file.

Please tell me how I can ban my event performing only once a day, and the next event should take place the next day.

Thank you

Sub run()


Application.run "'C:\Users\850051636\OneDrive - Genpact\Desktop\Working\Project 5 WIP Stock Transfer\Working QPA_Stock Transfer_Draft_v1.0.xlsm'!Module1.test"

End Sub

 

[maabadi]

Welcome to MrExcel Message Board.
Change Cell A1 if you have data on it.
You Can Try this:

Sub run()
If Range("A1").Value = Date then exit sub 
Application.run "'C:\Users\850051636\OneDrive - Genpact\Desktop\Working\Project 5 WIP Stock Transfer\Working QPA_Stock Transfer_Draft_v1.0.xlsm'!Module1.test"
Range("A1").Value = date
End Sub

Also you can use workbook open event I think.