+ Reply to Thread
Results 1 to 2 of 2

Close one of two open workbooks leaving other open.

  1. 08-22-2017, 01:16 PM #1
    COURTTROOPER is offline
    Forum Contributor
    Join Date
    06-06-2017
    Location
    Phoenix, AZ
    MS-Off Ver
    2013
    Posts
    129

    Close one of two open workbooks leaving other open.

    I was wondering if Anyone has any code to auto save a specific workbook leaving any other workbook open. We have two to three workbooks open at one time. I tried the below listed code but I get an error code that says it can't run the macro. Any help is app 
    Please Login or Register  to view this content.
    reciated!
    Reply With QuoteRegister To Reply
  2. 08-22-2017, 01:38 PM #2
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Close one of two open workbooks leaving other open.

    Maybe:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Close other workbooks on open
    By gclode in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-27-2016, 03:19 PM
  2. [SOLVED] workbook won't close when other workbooks are open
    By Jerbinator in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-11-2016, 08:21 AM
  3. [SOLVED] Open workbooks update the main one and close the other workbooks
    By stojko89 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-18-2013, 07:12 AM
  4. [SOLVED] Open Multiple Workbooks, Record names, Copy paste to Active Workbook, Close the Workbooks
    By vba_madness in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-24-2013, 06:09 AM
  5. How to close open workbooks from an application get open filename call ?
    By leanne2011 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-10-2011, 10:41 PM
  6. Application Open/Close Event - Store Open and Close Times?
    By mccrimmon in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 07-13-2011, 04:21 PM
  7. Open Close workbooks
    By bbc1 in forum Excel General
    Replies: 2
    Last Post: 08-28-2005, 07:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1