Export query result to an Excel file (1 Viewer)

[ScottXe]

Currently I manually export a query result to an Excel file. I would like to create a button that is clicked to generate an excel file with the query result. How could I start with?

 

[Ranman256]

The button click runs a macro.
The macro runs import/export,
Transferspreadsheet ,
Set all the params...(filename,headers,etc)