Save AS Dialog.

[sky]

Hi,
When I do the manual Export, it does show me the Save
as Dialog box to save as different name to export. But
when I use the VBA code TransferText method as :
DoCmd.TransferText acExportFixed, "Report
Export", "qryReport", "C:\Name.txt".

This will automatic save the file as Name.txt. How do I
use the VBA coding to prompt me a Save as dialog box as
when I do it manually export? So, I can export and give an
option to save as different name.

 

[Allen Browne]

Although the File Dialog object offers Save As, it does not work (as you
discovered).

Use the API call instead:
http://www.mvps.org/access/api/api0001.htm

You are better of with the API approach. The File Dialog doesn't work in MDE
files, or runtimes, or earlier versions, or ...