Export multiple reports to different tabs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Kevin, did you get any reply to your message as I'm trying to do exactly the
same thing you were asking about.
 
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!
 
Back
Top