<div>
How are you going to send the file to the other user's computer? &nbsp;By email, or what?
</div>


How are you going to send the file to the other user's computer?  By email, or what?

<div>
<div class="content wysiwyg-content">
I want to, with a command button on a form, send a query result to a user's computer as an Excel file but allow them to select the location it is to go to on their computer and name the file.<br />
<br />
How can I do this? &nbsp;Right now I have:<br />
<br />
DoCmd.TransferSpreadsheet acExport, 10, &quot;qryShipments&quot;, Environ(&quot;userprofile&quot;) &amp;&nbsp;&quot;\Desktop\Inventory.xlsx&quot;,<wbr /> True<br />
<br />
But that sends it to their desktop by default and replaces the file that was there already if there was one.
</div>
</div>


I want to, with a command button on a form, send a query result to a user's computer as an Excel file but allow them to select the location it is to go to on their computer and name the file.

How can I do this?  Right now I have:

DoCmd.TransferSpreadsheet acExport, 10, "qryShipments", Environ("userprofile") & "\Desktop\Inventory.xlsx", True

But that sends it to their desktop by default and replaces the file that was there already if there was one.

Send query result to a user's computer as an Excel file but allow them to select the location and name the file

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.