Event Procedure Programming
 

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.

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.
.