+ Reply to Thread
Results 1 to 6 of 6

Save As dialog box using a button

  1. #1
    Registered User
    Join Date
    07-08-2019
    Location
    United States
    MS-Off Ver
    2019
    Posts
    29

    Exclamation Save As dialog box using a button

    Hello!! I hope all is well.

    Preface: I have a macro enabled excel file. Within that file, I have a button that the user can click and it will will pull up the Save As dialog box allowing the user to select the location to save the file.

    Issue: When the file dialog box is shown, I need the File Name to read: "Client_Name " & Range("AO3").Value which is a cell containing a date (mm-dd-yyyy) and the filetype to be a Macro Enabled workbook or .xlsm file. Currently, I have the file type showing up correct but I cannot get the File Name to update properly.

    Please Login or Register  to view this content.
    Even when I remove the fName string and type in the name I want in Filename:= it will not update.

    Help please!!! Thank you!!

  2. #2
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,467

    Re: Save As dialog box using a button

    Hi there,

    See if the following code does what you need:

    Please Login or Register  to view this content.

    Hope this helps - please let me know how you get on.

    Regards,

    Greg M

  3. #3
    Registered User
    Join Date
    07-08-2019
    Location
    United States
    MS-Off Ver
    2019
    Posts
    29

    Re: Save As dialog box using a button

    Hi Greg!

    Your code works perfectly! Thank you very much!

  4. #4
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,467

    Re: Save As dialog box using a button

    Hi again,

    Many thanks for your feedback and also for the Reputation increase - much appreciated!

    You're welcome - glad I was able to help.

    Best regards,

    Greg M

  5. #5
    Registered User
    Join Date
    07-08-2019
    Location
    United States
    MS-Off Ver
    2019
    Posts
    29

    Re: Save As dialog box using a button

    Hi Greg! I want to thank you again for your help.

    I did notice one thing the code was doing that I could use an explanation on: When I run the save button everything works correctly. It comes up as an Macro Enabled Workbook and the Initial File Name is 'Client_Name ##-##-#### to ##-##-####'. Which is what I want. However, I need the user to change 'Client_Name' to the actual client's name. When I do change it and hit save, the workbook still saves as 'Client_Name ##-##-#### to ##-##-####' instead of the saving what I typed in the box. Could you explain what is happening with that? Thank you!!

  6. #6
    Registered User
    Join Date
    11-14-2019
    Location
    US
    MS-Off Ver
    Office 10
    Posts
    26

    Re: Save As dialog box using a button

    Good Morning,

    I was searching for a code that would save active sheet,
    is there a way to modify code to save active sheet vs entire workbook?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 04-05-2014, 08:53 AM
  2. [SOLVED] Save as Dialog Box
    By shiva_reshs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-06-2013, 10:07 AM
  3. [SOLVED] automatic name in 'save as dialog box' ok, but does not actually save the file?!
    By Pluym in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-02-2012, 10:05 AM
  4. Save as dialog with predefined filename does not save
    By a94andwi in forum Excel General
    Replies: 2
    Last Post: 04-20-2012, 03:23 AM
  5. Save as and the regular save as dialog box appears
    By Jessica.Bush in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-30-2011, 06:57 AM
  6. Save As Dialog box in the way
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-04-2010, 02:26 PM
  7. Replies: 2
    Last Post: 03-09-2006, 04:20 PM
  8. Save As Dialog
    By Larry Dodd in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-26-2005, 09:07 AM

Tags for this Thread

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