<div>
Hi Ray<br />
<br />
I get cannot update. Database or object is read only. and I take it that 10 means windows 10? so each users PC has to be individual code?
</div>


<div>
what version of office are you using?<br />
if older than 2007, use<br />
<br />
<br />
<br />
docmd.transferspreadsheet acexport, 9, &quot;QueryName&quot;, &quot;C:\folderName\myexcel.xls<wbr />&quot;, true<br />
<br />
&nbsp;to open the excel file<br />
<br />
&nbsp;followhyperlink &nbsp; &quot;C:\folderName\myexcel.<br />
<br />
<br />
&lt;and I take it that 10 means windows 10?&gt; NO, it is the excel file format
</div>


<div>
Thanks Pat Isn't that trust settings in Excell a pain in the Ass.<br />
<br />
Code works though<br />
<br />
Thank you both.
</div>


<div>
I still get errors ray File is read only
</div>


<div>
Opening the file immediately could be a timing issue. &nbsp;Or it could be that no matter how long you wait, Access isn't going to let go of the Excel file until you close Access.<br />
<br />
Try putting a wait loop that waits at least 15 seconds. &nbsp;If that doesn't resolve the problem, you will probably have to not use the TransferSpreadsheet method. &nbsp;Instead, you would need to use OLE automation, open Excel, create the spreadsheet, close the spreadsheet, close the object, close Excel. &nbsp;I can't even guarantee that would work since I have never done this. &nbsp;Access is like a dog with a bone when it comes to not letting go of external files.
</div>


<div>
I am sorry Pat I meant with Rays reply. Yours worked straight off. &nbsp;My mistake sorry.<br />
<br />
Derek
</div>


<div>
<div class="content wysiwyg-content">
Hi All<br />
<br />
Does anyone have the code for a command button on a form to export the data from a named query to excel. The query is just a stand alone query and does not relate to anything on the command buttons form. It would be nice to open the excel document immediately after clicking the command button
</div>
</div>


Hi All

Does anyone have the code for a command button on a form to export the data from a named query to excel. The query is just a stand alone query and does not relate to anything on the command buttons form. It would be nice to open the excel document immediately after clicking the command button

Export to excel

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.