Results 1 to 4 of 4

GetSaveAsFilename

Threaded View

  1. #1
    Registered User
    Join Date
    03-17-2005
    Posts
    19

    GetSaveAsFilename

    I am running a MACRO with the following code in Office 2007 and Vista Enterprise:

    SaveFile = Application.GetSaveAsFilename(InitialFileName:=Nme + ", Portfolio Summary Report", _
                FileFilter:=Filt, FilterIndex:=1, Title:="Browse to Location for File")
    
            ActiveWorkbook.SaveAs Filename:=SaveFile _
                , FileFormat:=51, Password:="", WriteResPassword:="", _
                ReadOnlyRecommended:=False, CreateBackup:=False
    The save as box does not sisplay the file name "Nme" Instead, the name is blank. I have verified Nma does indeed contain a filename (printed it out), so I'm thinking there is a problem with the function. It used to work prior to some enhancement programming, but not now. Can anyone help?
    Last edited by Andy Pope; 05-06-2009 at 10:01 AM. Reason: c

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1