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.
Bookmarks