Export to Temp file via module

T

top4747

This is probably very elementary, but I am currently exporting my query
with this module:
....
Then
DoCmd.SetWarnings False
DoCmd.OpenQuery "Look-Up by Name", acViewNormal, acEdit
DoCmd.Close acQuery, "Look-Up by Name"
DoCmd.OutputTo acQuery, "Look-Up by Name",
"MicrosoftExcelBiff8(*.xls)", "d:\look-up by name.xls", True, "", 0
End If
....

However, i would love to be able to eport to the users 'temp' drive, so
that the excel file is not replaced every time it is exported. Can
anyone help???? Thanks so much!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting query to Temp drive 4
how do i export from access to user's temp drive? 0
Error message with Macro 1
Running Macro - output pivot table to excel - error message 2046 0
Using variables as table names in an append sql statemnt 1
Export to Excel with Parameter in Filename 1
How to Build an SQL Query on the Fly for Data Export to Excel 4
Macro saved as vba not working 0

Top