How would I export the results from an Access query to an Excel spreadsheet and at the same time open the spreadsheet to view the results by using a cmd button?

I've used this line of code to export information from a table to excel:

DoCmd.TransferSpreadsheet acExport, _
SpreadsheetTypeExcel9, "tblMain", _
"c:\bulk\Main.xls"

However, I have to manually find the excel file and open it to view the data.

If you know where the file will be put and what the name is, you just have to add some code after the one you already have to open the excell file...

So on the same action button you put the 2 codes one after the other...

You know how to do this?

Try this:
DoCmd.OutputTo acOutputQuery, "query name goes here", acFormatXLS, "path name goes here", -1

stealthdevil,

that line of code did it! thanks.