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