I want to transfer a report to Excel and format the spreadsheet. I currently use a macro in Excel, but would like to complete the whole task in Access. I tried using CopyRecordset, but ran into a lot of problems because my report's query has parameters based off of combo's in a form. Plus I'd like to keep the order of the fields used in the report. Any ideas of how to write the code in Access to export then format?

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel7, "queryReportName", "spreadsheetFilename"

Bye, S.