Hello,

I run multiple Queries in MS access and then export the output individually to seperate excel work books for further analysis.

I need help in automating this process. Is it possible to have all this done by just clicking a botton.

I want the process to

1. run all the ms access queries
2. Import all the data in excel. Output of each query is imported in a seperate worksheet in the same workbook.
3. Save the workbook in a specified location. Since this is a periodic excercise i want the file names to be named after the date on which this process is run.

Is it possible to write a macro which can do all the above.

I have a very basic undertanding of macros.

Thanks in advance.

A.S.