how do i export from access to user's temp drive?

T

top4747

I have created a module to do the following:
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)",
c:/Look-Up", True, "", 0

But i want to change the Output to the user's temp drive. how do i do this?
 

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

Error message with Macro 1
Running Macro - output pivot table to excel - error message 2046 0
Export to Temp file via module 0
Exporting query to Temp drive 4
How do I get actions to only run one at a time? 2
Export to Excel with Parameter in Filename 1
Using variables as table names in an append sql statemnt 1
DoCmd.SetWarnings False is not working 2

Top