+ Reply to Thread
Results 1 to 6 of 6

Save and Close All excel Workbook except Active Workbook

  1. #1
    Forum Contributor
    Join Date
    12-18-2019
    Location
    chennai
    MS-Off Ver
    excel 2010
    Posts
    141

    Save and Close All excel Workbook except Active Workbook

    I am trying to use Macro to Save and close all excel workbook except active one. I am trying with the below code.

    The below code is working vise versa. like closing active workbook only.
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Please help me to correct the above code

  2. #2
    Valued Forum Contributor
    Join Date
    11-04-2018
    Location
    Denpasar
    MS-Off Ver
    Excel 2010
    Posts
    777

    Re: Save and Close All excel Workbook except Active Workbook

    Maybe something like this ?
    Please Login or Register  to view this content.
    The code must be in the active workbook.

  3. #3
    Forum Contributor
    Join Date
    12-18-2019
    Location
    chennai
    MS-Off Ver
    excel 2010
    Posts
    141

    Re: Save and Close All excel Workbook except Active Workbook

    This is closing all workbook including active one.

  4. #4
    Valued Forum Contributor
    Join Date
    08-07-2014
    Location
    Quito, Ecuador
    MS-Off Ver
    Excel 2016 & 365, Windows 10
    Posts
    511

    Re: Save and Close All excel Workbook except Active Workbook

    You can try this:

    Please Login or Register  to view this content.
    Barriers are there for those who don't want to dream

  5. #5
    Forum Contributor
    Join Date
    12-18-2019
    Location
    chennai
    MS-Off Ver
    excel 2010
    Posts
    141

    Re: Save and Close All excel Workbook except Active Workbook

    Hi Not closing. I am running this Macro from Personal Macro Workbook. That may be the issue

  6. #6
    Valued Forum Contributor
    Join Date
    08-07-2014
    Location
    Quito, Ecuador
    MS-Off Ver
    Excel 2016 & 365, Windows 10
    Posts
    511

    Re: Save and Close All excel Workbook except Active Workbook

    I'm sory
    I made a mistake

    replace this line:
    Please Login or Register  to view this content.
    use instead this line:
    Please Login or Register  to view this content.

+ 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 active sheet as xls and pdf then close the workbook
    By mattless1 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-05-2019, 04:40 PM
  2. How to close the active workbook in Excel 2011?
    By audax in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 11-28-2018, 10:28 PM
  3. [SOLVED] Macro to close all workbooks except active workbook and one other named workbook
    By picton2000 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-01-2017, 06:03 PM
  4. VBA Code to close non-active workbook crashes excel
    By mwgates81 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-08-2015, 06:32 PM
  5. Save workbook, attach it to outlook email, close workbook?
    By Jasonhouse in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-27-2014, 11:52 PM
  6. [SOLVED] Edit code to close all workbooks except active workbook and other specific workbook
    By rocksan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-04-2012, 09:29 PM

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