Export data from a form

[Access_Help]

Try transfer to spreadsheet with the query as the output object source

DoCmd.TransferSpreadsheet, acExport, acSpreasheetTypeExcel19, "qry_export_from_class_view", "MarkGrid_Class.xls", True

The last part True overwrites any existing version.

Error: 2498

An expression you entered is the wrong data type for one of the arguments