+ Reply to Thread
Results 1 to 4 of 4

GetSaveAsFilename

Hybrid View

DonHuff GetSaveAsFilename 05-06-2009, 09:38 AM
Andy Pope Re: GetSaveAsFilename 05-06-2009, 09:57 AM
DonHuff Re: GetSaveAsFilename 05-06-2009, 01:03 PM
mudraker Re: GetSaveAsFilename 05-07-2009, 04:31 AM
  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

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: GetSaveAsFilename

    please use code tags in future


    Is Nme a variable containing the name or the actual text.

    For me either with an empty variable the ", Portfolio Summary Report" part is displayed.
    Cheers
    Andy
    www.andypope.info

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

    Re: GetSaveAsFilename

    Nme is a variable with a company name assigned.

  4. #4
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983

    Re: GetSaveAsFilename

    I don'y have or use 2007 so my reply may be wrong

    Is Filt a variable - if yes what is its value

    Shorting the command down to the following works ok for me in 2003
    SaveFile = Application.GetSaveAsFilename(InitialFileName:=Nme + ", Portfolio Summary Report", _
                 Title:="Browse to Location for File")
    Please Read Forum Rules Before Posting
    Wrap VBA code by selecting the code and clicking the # icon or Read This
    How To Cross Post politely

    Top Excel links for beginners to Experts

    If you are pleased with a member's answer then use the Scales icon to rate it
    If my reply has assisted or failed to assist you I welcome your Feedback.

+ Reply to Thread

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