P
Patrick
Hi all,
Each week, I need to take about 30 queries from access, and export them
to Excel. I then need to format the excel spreadsheets and email them
to various people.
I would like to automate this process so that I can just click a button
and it does everything for me. I have automated the formatting of the
spreadsheets fine, from within Excel, and I know I will be able to call
that procedure from access, the problem is exporting all the queries in
the first place.
Could someone explain how I loop through the queries in the database
and export any that start with "Lookahead Report" ?
Much appreciated.
Patrick
Each week, I need to take about 30 queries from access, and export them
to Excel. I then need to format the excel spreadsheets and email them
to various people.
I would like to automate this process so that I can just click a button
and it does everything for me. I have automated the formatting of the
spreadsheets fine, from within Excel, and I know I will be able to call
that procedure from access, the problem is exporting all the queries in
the first place.
Could someone explain how I loop through the queries in the database
and export any that start with "Lookahead Report" ?
Much appreciated.
Patrick