Event Procedure Programming

J

Jeff Armstrong

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 - VBA to get a list of Module names in the project 4
manipulate other program using excel macro 2
Which Excel event to call when opening a .txt file 1
Refresh Macro to run each day? 2
Why do charts disappear? 2
Launch Excel On Event? 2
Intuitive Macro that changes based on cell value 13
Macro for event procedure 1

Top