Excel transfer and format

[Ack]

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?

 

[S]

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

Bye, S.