I am assuming you have the query completed.

If that is true, what is the queries name?

If the query is completed, and you just want to view it in Excel,

Lookup the OutputTo command in the help:

[VBA]DoCmd.OutputTo acOutputQuery, YourQueryName, acFormatXLS, "NewBook.xls", True[/VBA]