I want to record the result of a request and to save it like a excel file.
Hence I use that function:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, "ShowList_Request", "list.xls"
But it saved it in c:\Data. I would like to save it in the current directory, or in the proper one, (correct workspace of the user whatever the computer used).
Could you help me?
Thank you in advance!