| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to run macro with scheduler
thanks a lot - it works
"JLatham" wrote: Maybe explain a little more about what you want to do? Can you run the macro on File Open? Yes. Use the Workbook's Workbook_Open() event process to either run the code or to make a call to the code if written into another module. To get to the Workbook's _Open() event section, right click on the Excel icon to the left of the word "File" in the menu bar and choose [View Code] from the list that appears. In the lefthand pulldown above the large code module area, choose Workbook, and Workbook_Open() is the default 'stub' that will be started for you. Can you run the code as a VBA file? No. The Excel file has to be open for the code in it to be executed. "Dan" wrote: What is the best way to run an excel macro with the scheduler?? - is it possible to run the macro on file open?? how - is it possible to run directly the macro as a VBA file?? - maybee another way?? thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a random scheduler. | Excel Discussion (Misc queries) | |||
| task scheduler | New Users to Excel | |||
| Lost items in task scheduler | New Users to Excel | |||
| Scheduler and passwords | Excel Discussion (Misc queries) | |||
| Is there a diary/scheduler in Office, rather than Outloook | Excel Discussion (Misc queries) | |||
Hybrid Mode
