FileDialog

[Richard Albrecht]

I'm a Delphi programmer and am trying to figure out how one opens a File
Save dialog. I'm using the DoCmd.OutputTo (Can't remeber exact name) to
save a query to an excel spreadsheet. However I want to Name the file but
give the user the abilitie to save the file anywhere.

In other words I want a save as file dialog to pop up with a suggested name
for the file. How does one do this in Access 2000 in VBA code?

Thanks

Rich

 

[Dirk Goldgar]

I'm a Delphi programmer and am trying to figure out how one opens a
File Save dialog. I'm using the DoCmd.OutputTo (Can't remeber
exact name) to save a query to an excel spreadsheet. However I want
to Name the file but give the user the abilitie to save the file
anywhere.

In other words I want a save as file dialog to pop up with a
suggested name for the file. How does one do this in Access 2000 in
VBA code?

Thanks

Rich

The best way for Access 2000 or earlier is to call the Windows API
directly. You'll find code for this, with examples, at:

www.mvps.org/access/api/api0001.htm

 

[Allen Browne]

Richard, Dirk is right.

Although the FileDialog object of the Office library offers a SaveAs in the
intellisense options, it does not work in Access.