Export multiple reports to one workbook

K

Kevin

I'm trying to export multple Access reports to one Excel Workbook.

Let's say the reports are named "ReportA", "ReportB", and "ReportC" and the
workbook is called "C:\TestWorkbook.xls". Does anyone know how to do this?

Ideally I would like to be able to change the formatting of the spreadsheets
after export, but maybe that's a topic for another thread.

Thanks in advance,
Kevin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export multiple reports to different tabs 2
Tracked changes by multiple people modified to one 0
Copy a worksheet to a new workbook 6
export query data to excel in a specific worksheet. 2
Hidden Excel Workbook after automation 13
Export three reports to one spreadsheet 2
Export Sheet Values to new workbook 20
Export(Save AS) workbook without macro on browse location 0

Top