Link to home
Start Free TrialLog in
Avatar of etech0
etech0Flag for United States of America

asked on

Access VBA export two queries to two worksheets in same excel file

Hi! I'm using this line of code to export a query to excel.
DoCmd.OutputTo acOutputQuery, "SalesRepMonthlyReport", acFormatXLSX, "c:\file.xlsx", true

Open in new window

I would like to export another query to the same Excel file, but in a different sheet.
Is that possible?

Thanks!
ASKER CERTIFIED SOLUTION
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of etech0

ASKER

Nice - thanks a million!