Hi All,

I use to run daily 110 access queries for users. Daily i use to copy a mdb file which contains all queries from share drive. All queries are passthru queries so every time when i click on query it will ask me password, so for each query i have to enter password and it will run.

Is there any way to automate it so that all queries will run and and each queries output is saved in excel isn perticular location plss... help mee..