|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
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?
|
|
|