FileDialog

[Robert M via AccessMonster.com]

In my 2003 Access database I would like to allow my users to output the
results of a query to an Excel file. How do I use the FileDialog object so
that users can select an existing file to overwrite and/or save to a new
file/location?

 

[Allen Browne]

You can't.

The FileDialog object does not support the SaveAs option in Access, even
though it appears to. Additionally, it requires an extra reference to the
Office library: one more that can go wrong and prevent not just that code
but the entire application from working, and another issue if you have to
move between versions. Even worse, it is not supported under the runtime
environment.

The most sensible solution is to ignore the object, and use an API call to
get the Windows FileSaveAs dialog box instead. Details in:
Call Windows File Open/Save Dialog box
at:
http://www.mvps.org/access/api/api0001.htm

 

[Robert M via AccessMonster.com]

You can't.

The FileDialog object does not support the SaveAs option in Access, even
though it appears to. Additionally, it requires an extra reference to the
Office library: one more that can go wrong and prevent not just that code
but the entire application from working, and another issue if you have to
move between versions. Even worse, it is not supported under the runtime
environment.

The most sensible solution is to ignore the object, and use an API call to
get the Windows FileSaveAs dialog box instead. Details in:
Call Windows File Open/Save Dialog box
at:
http://www.mvps.org/access/api/api0001.htm

 

[Robert M via AccessMonster.com]

Thanks, works great. Guess I should have heeded advice for all the previous
posters of same problem.