| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Event Procedure Programming
Hi
try the OnTime method. See: http://www.cpearson.com/excel/ontime.htm -----Original Message----- I have 4 reports in Excel that I have automated using VBA. At this point I have to open each report and run the macros manually. I would like to get my reports to the point where they will run every day at a specified time. I believe this is done using Event Procedures. I've never done any of this. Can anyone give me some resources on the web that gives examples of these types of programming? I think the real challenge will be to have my computer some how open the files prior to the time I specify for the macros to run. Otherwise I will have to leave the reports open in Excel all the time. If someone also knows of a program or a way to schedule this, it would be a big help. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| workbook_Open event Procedure | Excel Discussion (Misc queries) | |||
| workbook_Open event Procedure | Excel Discussion (Misc queries) | |||
| Using VBA to track changes in a worksheet - help! Event procedure?? | Excel Programming | |||
| OnTime event not firing in Workbook_Open event procedure | Excel Programming | |||
| Programming a current procedure | Excel Programming | |||
Hybrid Mode
