Executing Query to Excel?

[objNoob]

I'm designing a form in Access and I'd like the user to be able to click a command button that executes a query and opens the results in Excel, instead of displaying the results in Access.



I want the user to be able to use Excel to decide what she or he would like to do with the results.

Any suggestions on how to accomplish this?

[objNoob]

I was able to achieve this using CreateObject("Excel.Application") and saving my query as a RecordSet which allowed me to pass that to Excel.

Thanks to all who took a looksee!