+ Reply to Thread
Results 1 to 3 of 3

Save As Dialog box that actually saves

  1. #1
    Forum Contributor
    Join Date
    06-26-2014
    Location
    Houston
    MS-Off Ver
    365
    Posts
    196

    Save As Dialog box that actually saves

    Hi,

    I really hate to ask this as I see tons of results when searching for this, but I cant seem to figure out exactly how to do this. All I'm looking for is the code to open the Save As Dialog box, doesn't matter which folder although I can choose one if necessary, and when I name it, and hit save, it actually saves. I have seen that one of the codes opens the dialog box, but when you choose the file to overwrite, it doesn't actually save it. I dont want it to actually save, I just want the last part of a macro to be to open the save as box and allow me to either name the file or overwrite an existing one.

    Thanks!

  2. #2
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Save As Dialog box that actually saves

    Please Login or Register  to view this content.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  3. #3
    Forum Contributor
    Join Date
    06-26-2014
    Location
    Houston
    MS-Off Ver
    365
    Posts
    196

    Re: Save As Dialog box that actually saves

    You're the man!

+ 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. Save Button that looks up latest file in folder, adds one and saves
    By Kucster in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-14-2014, 11:55 AM
  2. At A Loss: Click Save - Saves To Multiple Locations
    By MACanada in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-16-2014, 10:04 AM
  3. Replies: 1
    Last Post: 07-12-2012, 11:00 PM
  4. [SOLVED] Save as saves selected worksheet instead of whole workbook
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 06-05-2006, 01:55 AM
  5. Replies: 2
    Last Post: 03-09-2006, 04:20 PM
  6. [SOLVED] when I save a file from Excel 2003 to cd it saves as read only
    By mmjjmm in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-13-2006, 09:20 PM
  7. Re: Save As CSV saves empty rows
    By Dave Peterson in forum Excel General
    Replies: 2
    Last Post: 02-18-2005, 10:06 AM

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