Export to Excel - Multiple Worksheets

[alexfwalker81]

I have 4 crosstab queries which I can export successfully to .xlsx, using ExportWithFormatting in a macro. However, I'd really like to be able to write the first crosstab to a new workbook, then append the following 3 crosstab queries as subsequent worksheets within the workbook. Is that possible?

 

[Isaac]

One way you can do this is to use Excel automation, combined with the CopyFromRecordset method.

 

[theDBguy]

Hi. Maybe you could also try using the TransferSpreadsheet method.