Run Macro when date changed

[naveenmarapaka]

Hi,
I am looking to run a macro when date changed in system...

what can be my code......

can some one help here...





regards

[Bernie Deitrick]

Do you want to run a macro at midnight? Or do you mean that the date was changed by the user through the control panel?

[naveenmarapaka]

When date changes in system automatically, my macro should run.....when my system is on....

it means, daily 1 time macro will run.....

[Bernie Deitrick]

If your system is on all the time, you can schedule a macro to run once per day. If you turn off your system, you can use a workbook open event to run the macro and record that it has been run (in case the workbook is closed, then re-opened).

For the second case, in the workbook that has the macro, named RunMeOncePerDay and a sheet named "Sheet1", code like this, copied into the code module of the ThisWorkbook object, will run the macro once when the workbook is opened (if you use Personal.xlsb then it will be opened every time you start Excel):

Please Login or Register  to view this content.