Connecting Tech Pros Worldwide Forums | Help | Site Map

Macros to run and export multiple reports

Makuhari1998
Guest
 
Posts: n/a
#1: Nov 12 '05
Is it possible to create a macro that will open 7 reports at once and
automatically export the results of each report into Excel? Can the
results be exported into the same Excel workbook, or will they be in 7
different workbooks? Can I create a button on the main form of my
database to run this macro?

Also, is it possible to write a macro that can open several *queries*
at once and export them into Excel? If so, will the data labels of the
fields be exported into Excel as well?

Thanks for your assistance with my questions.
Closed Thread