Autorun

[jonnymenthol]

Hello, I wonder if anyone can help me please ?

I have a DB with x number of Macros in. Eahc of the macros pulls together data from certain tables and queries, then outputs the data into Excel.

Once there, it does a few things in Excel (run Pivot Tables etc.)

I have to run these macros every morning, so would like to know What is the easiest way to automate the running of these macros?

Apologies if I haven't made myself very clear.

Cheers.

Jonny.

 

[Mile-O]

Use the Windows Scheduler to open the database.
Have a macro called autoexec so that once the database opens it knows what other macros to run.