+ Reply to Thread
Results 1 to 3 of 3

Save As but keep active wb open but the Save As .close

  1. #1
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    818

    Save As but keep active wb open but the Save As .close

    Good day,
    I am playing around my save as method. I have the following code and I think I know I will get it. I have a command button in my sheet that will Save As my Range:

    Please Login or Register  to view this content.
    Problem is that it closes my original file and opens the new file that was created I need to have the original wb stay open and that the new one close.

    What would I be missing?

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Save As but keep active wb open but the Save As .close

    Perhaps you could use SaveCopyAs.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    818

    Re: Save As but keep active wb open but the Save As .close

    I knew I was just missing one small thing

    Thank you Norie

+ 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: 1
    Last Post: 10-25-2013, 06:10 PM
  2. Replies: 13
    Last Post: 02-13-2013, 01:00 PM
  3. [SOLVED] VBA to open, edit, save and close
    By AZZ70 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-24-2012, 02:01 PM
  4. Save and Close Open File
    By cmcgath in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-17-2010, 10:35 AM
  5. Open WB / Run Macro / Save changes /Close WB
    By nachousa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-24-2010, 01:08 PM

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