Export Multiple Queries to xls 97-2003 separte worksheets same workbook

[jsonlee]

Ive googled and googled and have found bits and pieces of useful info on how to achieve this but struggling to put it all together. I am using Ms access 2010 and have been assigned a task to update an already functioning export that allows users to pick a qry from a listbox. Clicking an export button opens the save as dialogue where users pick 97-2003 and assign a filename and save.



I would like to do the same exact thing but with 2 separate queries into 2 separate worksheets on the same workbook.
Current code accomplishes the single worksheet example.
DoCmd.OutputTo acOutputQuery, strQryName

Thanks,
Jason

[aytee111]

Use DoCmd.TransferSpreadsheet - the file name will remain the same and the sheet name will be taken from the query name.