Error Message Trying to Use "Save As" Dialog

  • Thread starter Thread starter J. Trucking
  • Start date Start date
J

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
 
Back
Top