TransferSpreadsheet...Maintain formatting

[jgelpi16]

I am wanting to export some query results into an excel spreadsheet and would like to maintain the formatting. I have the fields in my query formatted to Currency and Standard. Is there a specific Spreadsheet Type I can use?

    varExportQuery = "CountTP_ByWeek"
    varExportLoc = "C:\FileLocation" & varExportQuery
    DoCmd.TransferSpreadsheet acExport, , varExportQuery, varExportLoc

[NTC]

am not sure what is meant by 'spreadsheet type'.

be sure to look into the 'export specification' feature of Access - - I think this will provide what you need.