Choosing file name when exporting to Excel

[p595659]

Hi,
I would like to have a dialog box open when the user clicks on a command box so that they can choose the file name and the directory where the exported excel spreadsheet would be saved. Does anyone have any ideas? Btw, my code to save an excel automatically is below and I would like to use code.

DoCmd.OutputTo acQuery, "qryPipelineAndCommission", "MicrosoftExcel(*.xls)", "ClientList.xls", True, ""

Cheers,
Ben

 

[KenHigg]

I would think you could simply leave that option empty;

DoCmd.OutputTo acQuery, "qryPipelineAndCommission", "MicrosoftExcel(*.xls)",, True, ""

???

 

[p595659]

Hey Ken,
yup that did the trick.

Ben

 

[KenHigg]

.
.
.
Cool