Timer execution

[olarge1]

Hi,

This may be really simple and i am being slow. I have created a Macro that outputs a querie table into an excel table with a date filter applied. I want this to execute automatically overnight so i dont have to access the database each morning but can use the exported excel data as soon as i want.

i have got scheduler to open the database but cant seem to get it to access the macro. I cant set the macro as autoexec as other users use the file and hence each time they open it they will change my data.

Is there a way to set a autoexec to only execute at a certain time or for the windows scheduler to open the macro. The database is on a network drive by the way.


Thanks

Olarge1

 

[Joe4]

How about doing something like this:

Create a new database that "links" into your main database (you can link the data tables, and copy over the queries you need to this new database).

Then make the autoexec procedure on this new database, and run that with the scheduler every night. Hence, this new database will have access to the "real" data, but will do the queries in a separate location.

 

[Philem]

Hullo. You mentioned that you "got the scheduler to open the database..." Good. Now simply alter the command line that opens the db to include /X macroname at the end. This will launch said macro when the db starts.

HTH

P