Open Excel then Run Macro and Close on Schedule
Posted by PinkyTwister on January 10, 2002 4:06 PM
I want to open a specific file in Excel and run a macro and then close the program completely. I want this to run twice a day at a specfic time. I know how to run macros that close the worksheet but how do I set this to run twice a day when Excel is not open to run this macro? Please advise!
Posted by Nate Oliver on January 10, 2002 6:06 PM
This may be of interest to you. I think you'll need to have Excel open, but not the specific file if you place this in your personal.xls file and your procedure opens the target file.
Good Luck!
http://www.cpearson.com/excel/ontime.htm
Posted by Martius on January 10, 2002 7:21 PM
And ....
.... you could open Excel with Windows' Task Scheduler.
: I want to open a specific file in Excel and run a macro and then close the program completely. I want this to run twice a day at a specfic time. I know how to run macros that close the worksheet but how do I set this to run twice a day when Excel is not open to run this macro? Please advise!
Posted by Nate Oliver on January 11, 2002 1:45 PM
And ....So much for my job
Very choice Martius! Cheers
