Exporting Query Results to Excel at the Press of a Button

[esh112288]

I currently have a button that runs a query I've written. Rather than run the query and open the results in Access, I'd like for those results to automatically export to Excel. I have very little programming experience and am not sure how to make this happen. Any help would be appreciated.

[JoeM]

You can use a Macro to do that. Take a look at the TransferSpreadsheet macro action. It explains each argument in detail, and if you press F1, you will get Advanced Help.

[alcapps]

there is a vba.. docmd. as well

docmd.TransferSpreadsheet

check that out..

[JoeM]

there is a vba.. docmd. as well

docmd.TransferSpreadsheet

check that out..

Its the same command that the Macro uses. The advantage with the macro is that you do not need to know VBA. The advantage with VBA is you can make it more dynamic.
One great tool is the utility that "Converts Macros to Visual Basic". You can start with a basic macro. Then, if you use that utility to convert it to VBA, it will convert it to the VBA code you need. You can then edit the VBA code if you want to make it more dynamic.