<div>
Hah, easy when you know how....! &nbsp;Thanks very much..
</div>


Hah, easy when you know how....!  Thanks very much..

<div>
<div class="content wysiwyg-content">
I am currently using docmd.output to and exporting various queries in to separate Excel workbooks. Ideally I would like to export these queries to separate worksheets within one workbook and name the worksheets with the same name as the query.<br />
<br />
This is what I do currently.<br />
<br />
DoCmd.OutputTo acOutputQuery, &quot;Bens CC&quot;, &quot;Excel97-Excel2003Workbook<wbr />(*.xls)&quot;, &quot;z:\mi\BensCC.xls&quot;, False, &quot;&quot;, , acExportQualityScreen<br />
&nbsp; &nbsp; DoCmd.OutputTo acOutputQuery, &quot;Cab CC&quot;, &quot;Excel97-Excel2003Workbook<wbr />(*.xls)&quot;, &quot;Z:\MI\CABCC.XLS&quot;, False, &quot;&quot;, , acExportQualityScreen<br />
<br />
Thanks for any advice
</div>
</div>


I am currently using docmd.output to and exporting various queries in to separate Excel workbooks. Ideally I would like to export these queries to separate worksheets within one workbook and name the worksheets with the same name as the query.

This is what I do currently.

DoCmd.OutputTo acOutputQuery, "Bens CC", "Excel97-Excel2003Workbook(*.xls)", "z:\mi\BensCC.xls", False, "", , acExportQualityScreen
    DoCmd.OutputTo acOutputQuery, "Cab CC", "Excel97-Excel2003Workbook(*.xls)", "Z:\MI\CABCC.XLS", False, "", , acExportQualityScreen

Thanks for any advice

MS Access export multiple queries to separate worksheets in Excel workbook

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.