scheduled in the future to auto-run macro

hi,

is it possible to run a macro on a specific date and time in the future?
when the file is opened and the specified date and time is the same as the current date-time when it was opened
or the date-time it was opened is past the date-time specified in the code

for example:
on Feb 28, 2018 at 10am
automatically get the sum of G2 and H2 and put it in I2
make the format in I2 bold and red color

Check this out: http://www.utteraccess.com/wiki/Schedule_a_Macro_to_Run

It uses the windows task scheduler. It's a three-step process, you create a script. The script gives you a string to run itself when the task scheduler says to run it. The script runs the macro in the target workbook.

thanks for the tip

i think it runs all the code inside the workbook open sub
i already have several code in my workbook open sub for my excel file
i just need to run a portion of a code inside the workbook open sub for a certain scheduled date-time
but this will run all the code

im thinking is there a way in excel to compare dates
(im ok if i can only compare date and not include the time)
feb 28, 2018 and date the workbook is opened
and using an IF STATEMENT if feb 28, 2018 is same as the date it was opened
or the date it was opened is past feb 28, 2018
then i can run my desired code inside the IF STATEMENT

edit:
so i found this, it works for me

Please Login or Register  to view this content.

I prefer to design my reports so I can open them and work on them without macros running, so that's why the "target" reports don't have on open events.

The scripts, on the other hand, do run code with an on open event. The scripts open the target report and run the specified macro (usually I call this Executive) which sometimes runs other macros to refresh data, set pivot table filters etc.

Going back even one more step, the windows task scheduler opens the script and since it has an on open event, it runs the macro in the target workbook.

There is a point in setting up the task scheduler where you have to enter in the command to run. The script provides this string so you can copy and paste it at that point in the task scheduler setup.

The task scheduler does nice things like "Run every other Sunday night at 10 PM." I don't have to figure out how to do that.