Error Message Trying to Use "Save As" Dialog

[J. Trucking]

Hello,

I have some vba which uses TransferSpreadhseet to export the results
of a query. Currently, it is set to save to the same directory as the
DB. However, I would like to change this and give the user the
ability to rename the file and save it to whatever directory they
choose. So I tried both of the following (not at the same time):

Application.GetSaveAsFileName
Application.Dialogs(xlDialogSaveAs).Show

I get the same error both times "Method or Data Member Not Found".
Has anyone ever had this happen before? My vba to export the sheet is
Option Explicit so I am assuming I am going to have to declare the
save as dialog somehow or revise my references. However, I'm not
exactly sure how to do that. Any suggestions?

Thanks in advance,

John

 

[Graham R Seach]

You need to set a reference to the Office library.

1. Open any code module.
2. From the Tools menu, select References.
3. Locate and select the Office x.x Object Library.
4. Click OK.

Then see the following web page for information about how to use the
FileDialog object:
http://msdn.microsoft.com/en-us/library/aa190811(office.10).aspx

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[strive4peace]

Hi John,

look here:

API: Call the standard Windows File Open/Save dialog box
http://www.mvps.org/access/api/api0001.htm

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*