Export multiple reports to different tabs

[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

 

[SB-1]

Kevin, did you get any reply to your message as I'm trying to do exactly the
same thing you were asking about.

 

[Kevin]

Unfortunately not. It seems like you can only export to multiple sheets with
the transfershreet command, which means that you just get flat text- no
formatting. The sheets are named whatever the reports are named.

I did get one letter back (on a different thread, same topic) that suggested
I record the macro in Excel to get the code for the formatting and then run
that code in Access. I didn't have any luck getting that to work.

Please let me know if you have any luck- I could still use it!