help needed to export a quarie to excel

[cslr]

Hello i am trying to export a querie to an excel file using a vba or a macro .
i have done some stuff with macro but nothing with vba.


i now how to export a table and a report but can not seem to be able to gat a querie to export .
thank for any help any one can give me

[boblarson]

You can use DoCmd.TransferSpreadsheet, or you could copy the function from my website:
http://www.btabdevelopment.com/ts/de...aspx?PageId=48
into a standard module so you can just call it and pass the query name to it. Make sure the standard module (not form, report or class module) is not named the same as the function.

[cslr]

thank you so muck for your help . i will try that right now .