Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically Execute Excel Macro at 6:00 am
I have an excel macro that I need to execute at 6:00 am Monday morning
-- a time that I'd prefer not to be at the office. My thought that I could leave the Excel file open over the weekend and program it to automatically execute the Macro at the desired time. Can this be done? If so, how? Thanks! Scott |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically Execute Excel Macro at 6:00 am
I'm probably not qualified to answer this question but I had a thought on how
to accomplish this. Set the macro in the auto_open portion of workbook and use windows scheduled tasks to open the file at 6:00 am Monday morning. Of course this would also require macro security to be set to low. There may be some way to include timing within excel, I'm just not knowledgeable enough to comment on that aspect :) "scott" wrote: I have an excel macro that I need to execute at 6:00 am Monday morning -- a time that I'd prefer not to be at the office. My thought that I could leave the Excel file open over the weekend and program it to automatically execute the Macro at the desired time. Can this be done? If so, how? Thanks! Scott |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically Execute Excel Macro at 6:00 am
See:
http://www.cpearson.com/excel/OnTime.aspx Just be sure to set RunWhen to an absolute date/time rather than Now+ an increment -- Gary''s Student - gsnu2007a "scott" wrote: I have an excel macro that I need to execute at 6:00 am Monday morning -- a time that I'd prefer not to be at the office. My thought that I could leave the Excel file open over the weekend and program it to automatically execute the Macro at the desired time. Can this be done? If so, how? Thanks! Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to execute a macro automatically | Excel Programming | |||
How to execute a macro automatically at startup of Excel? | Excel Programming | |||
Execute Macro automatically after hyperlink | Excel Discussion (Misc queries) | |||
Automatically execute a macro | Excel Programming | |||
If values in two columns are equal I want to automatically execute a macro | Excel Programming |