[AccessD] Use of Application.FileDialog(msoFileDialogSaveAs) in Access 2007

All,

I have just started to experiment with Application.FileDialog(msoFileDialogSaveAs).

We have an Access 2007 application that uses “DoCmd.TransferSpreadsheet” to generate several Excel files from Access Queries.  Currently this application has the name of the Excel file “hard coded” in the application.

I would like to give our end-users the option of changing the name of the Excel file (and folder name) when the file is generated. 

Using  Application.FileDialog(msoFileDialogSaveAs) seems to work nicely, but I am a bit concerned that this may not be a good long-term approach.

When doing research about this method, I stumbled upon this statement on a Microsoft web page.

“ msoFileDialogSaveAs constants are not supported in Microsoft Office Access 2007”

This, and other comments that I have read have made me wonder if I am heading down the wrong path. (no pun intended) 

Is Application.FileDialog(msoFileDialogSaveAs) a viable approach?

Is there a better way to give the end-users an easy way to change the name (and folder) of the generated Excel file?

Thanks,
Brad