Macro to EXPORT to Excel

[TimE]

I would like to create a command button to export a query or report to excel. Is this possible and if so, how?


Thanks in advance for any assistance.

 

[Hayley Baxter]

The following code will export a query to an excel sheet.

Sub export_to_excel()
Dim mfile
myfile = "Your path name/spreadsheet name.xls"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "your query name", myfile
End Sub()

Hay