<div>
That is helpful for future reference but what I'd really like to emulate is what happens when you run an OutputTo macro where the file name is left blank. &nbsp;In that case you are presented the windows &quot;Save As&quot; dialogue screen defaulting to MyDocuments.
</div>


That is helpful for future reference but what I'd really like to emulate is what happens when you run an OutputTo macro where the file name is left blank.  In that case you are presented the windows "Save As" dialogue screen defaulting to MyDocuments.

<div>
Thanks... It appears this will work. &nbsp;Regardless, it most likely will serve me well for future reference. &nbsp;Since it is fairly complex, relative to my puny mind, I think I'll just &quot;RunMacro&quot; instead and leave the file name blank as mentioned in my original question. &nbsp;Thanks!
</div>


Thanks... It appears this will work.  Regardless, it most likely will serve me well for future reference.  Since it is fairly complex, relative to my puny mind, I think I'll just "RunMacro" instead and leave the file name blank as mentioned in my original question.  Thanks!

<div>
<div class="content wysiwyg-content">
Capricorn1 gave me the answer for VBA code to export a query to Excel. &nbsp;Now I'd like to know how to make that query prompt for file name rather than hard-coded as in his answer: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, _<br />
&quot;queryName&quot;, &quot;C:\myQuery.xls&quot;, True, &quot;&quot;<br />

</div>
</div>


Capricorn1 gave me the answer for VBA code to export a query to Excel.  Now I'd like to know how to make that query prompt for file name rather than hard-coded as in his answer: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, _
"queryName", "C:\myQuery.xls", True, ""


MSAccess How to prompt in export to Excel VBA statement

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 applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.