Export A Table To Excel By Click of a Button

[xeen20]

Hi,
I would like to export a table formed by a Query into a excel sheet with a Click of a Customized button. can Anyone help me how to do that.

I can do that by going to file and export to excel sheet but i need it to be done with a button of my own .

 

[ajetrumpet]

Will the TransferSpreadSheet option in the macro window work for this??

 

[xeen20]

Thank you for the soultion,
BUt
I wrote a macro for it but its not working.
i got F1 field error.
i solved it by naming the columns
but even then its not working and even giving any error.
thanks

 

[GaryPanic]

output to perhaps???

 

[xeen20]

the output tO EXCEL