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!
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!