<div>
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.<br />
<br />
I have recommended this question be closed as follows:<br />
<br />
Split: <br />
-- Dale Fye (<a href="https:#a42432816" rel="ugc">https:#a42432816</a>)<br />
-- PatHartman (<a href="https:#a42432818" rel="ugc">https:#a42432818</a>)<br />
<br />
<br />
If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.<br />
<br />
MacroShadow<br />
Experts-Exchange Cleanup Volunteer
</div>


No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Split:
-- Dale Fye (https:#a42432816 [https:#a42432816])
-- PatHartman (https:#a42432818 [https:#a42432818])


If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

MacroShadow
Experts-Exchange Cleanup Volunteer

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I have a command button on a MS Access form. &nbsp;I want the click event to run an SQL query and show the results in an excel spreadsheet. &nbsp;I want the user to have the option of saving the spreadsheet or just closing the spreadsheet out. &nbsp;Is there a way to do this every method I've tried prompts you to save the spreadsheet first to a file location. &nbsp;Example:<br />
<br />
DoCmd.OutputTo objecttype:=acOutputQuery,<wbr /> objectname:=&quot;Parent and Child Benefit Rules&quot;, outputformat:=acFormatXLS<br />
<br />
Thanks
</div>
</div>


Hello,

I have a command button on a MS Access form.  I want the click event to run an SQL query and show the results in an excel spreadsheet.  I want the user to have the option of saving the spreadsheet or just closing the spreadsheet out.  Is there a way to do this every method I've tried prompts you to save the spreadsheet first to a file location.  Example:

DoCmd.OutputTo objecttype:=acOutputQuery, objectname:="Parent and Child Benefit Rules", outputformat:=acFormatXLS

Thanks

MS Access Open Query Results in Excel Spreadsheet

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

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

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.