Export Access data to Excel (2010) Let user choose save destination?

Hi,

Here the code I use to transfert data from an Access query to an Excel file.

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "qry_Transfert_XL_Client", _
"S:\Client\Test.xlsx", True

Instead of specified the destination, ""S:\Client\Test.xlsx"", How can we let the user choose the destination?


Thanks