db-Q-25949070.mdb

<div>
Option 1: User uses Windows Explorer and navigates the path, copies the path, and pastes the path into an unbound textbox on the same form as the export button. You can then do something like this near the top of your sub<br />
OutPutPath = txtCopiedPath &lt;-- the name of the unbound textbox<br />
Option 2: Use the CommonDialog Class under ActiveX Controls<br />
Option 3: Use a tedious combination of comboboxes and listboxes and events - not recommended<br />
Lee<br />

</div>


Option 1: User uses Windows Explorer and navigates the path, copies the path, and pastes the path into an unbound textbox on the same form as the export button. You can then do something like this near the top of your sub
OutPutPath = txtCopiedPath <-- the name of the unbound textbox
Option 2: Use the CommonDialog Class under ActiveX Controls
Option 3: Use a tedious combination of comboboxes and listboxes and events - not recommended
Lee


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have many Queries that Excel Exports to an .xls, at a determined directory, like so, <br />
<br />
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel7, &quot;ASP&quot;, &quot;C:\Databases\Access to Excel.xls&quot;, True <br />
<br />
This executes when a user pushes a button on a form.<br />
<br />
Now, i need to substitute my &nbsp;Path, &nbsp;&quot;C:\Databases\Access to Excel.xls&quot;, with a Variable<br />
<br />
let say &quot;Dim OutPutPath&quot;, And let the user select the output directory, via windows explorer,<br />
<br />
so it copies the path information the user selected to my &quot;OutPutPath&quot; variable, since I need to export over 30 queries to Excel this way,and their is no way we can select the same directory in real time, 30 times!<br />
<br />
Thanks!
</div>
</div>


Hi,

I have many Queries that Excel Exports to an .xls, at a determined directory, like so, 

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel7, "ASP", "C:\Databases\Access to Excel.xls", True 

This executes when a user pushes a button on a form.

Now, i need to substitute my  Path,  "C:\Databases\Access to Excel.xls", with a Variable

let say "Dim OutPutPath", And let the user select the output directory, via windows explorer,

so it copies the path information the user selected to my "OutPutPath" variable, since I need to export over 30 queries to Excel this way,and their is no way we can select the same directory in real time, 30 times!

Thanks!

MS Access VBA - User sets output directory for Excel Exports

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.