+ Reply to Thread
Results 1 to 11 of 11

Multiple workbooks into one workbook - asked to save or not save each workbook step remove

  1. 03-19-2014, 01:45 AM #1
    Benji Jeff
    Benji Jeff is offline
    Registered User
    Join Date
    03-19-2014
    Location
    Sydney
    MS-Off Ver
    Excel 2016
    Posts
    15

    Multiple workbooks into one workbook - asked to save or not save each workbook step remove

    Using the script (as below) works great except I have to sit there and click no don't save each workbook as it flashes up.
    Be very grateful is someone could adjust the code so this step becomes automated as in don't save

    Very basic knowledge sorry
    Please Login or Register  to view this content.
    Last edited by Benji Jeff; 03-19-2014 at 02:20 AM.
    Reply With QuoteRegister To Reply
  2. 03-19-2014, 01:57 AM #2
    Trebor76
    Trebor76 is offline
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,523

    Re: Multiple workbooks into one workbook - asked to save or not save each workbook step re

    Hi Benjii,

    Welcome to the forum!!

    I think I know what the answer might be but before I can suggest it you need to wrap your code with the appropriate tags.

    Regards,

    Robert
    ____________________________________________
    Please ensure you mark your thread as Solved once it is. Click here to see how
    If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
    Reply With QuoteRegister To Reply
  3. 03-19-2014, 02:01 AM #3
    Benji Jeff
    Benji Jeff is offline
    Registered User
    Join Date
    03-19-2014
    Location
    Sydney
    MS-Off Ver
    Excel 2016
    Posts
    15

    Re: Multiple workbooks into one workbook - asked to save or not save each workbook step re

    Hi Robert

    Not sure if my previous reply got through, so new not sure what wrapping code with tags means

    Appreciate your guidance

    Regards
    Ben
    Reply With QuoteRegister To Reply
  4. 03-19-2014, 02:06 AM #4
    Trebor76
    Trebor76 is offline
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,523

    Re: Multiple workbooks into one workbook - asked to save or not save each workbook step re

    Your code needs to go in-between these tags [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE]
    Reply With QuoteRegister To Reply
  5. 03-19-2014, 02:09 AM #5
    Benji Jeff
    Benji Jeff is offline
    Registered User
    Join Date
    03-19-2014
    Location
    Sydney
    MS-Off Ver
    Excel 2016
    Posts
    15

    Re: Multiple workbooks into one workbook - asked to save or not save each workbook step re 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 03-19-2014, 02:11 AM #6
    Benji Jeff
    Benji Jeff is offline
    Registered User
    Join Date
    03-19-2014
    Location
    Sydney
    MS-Off Ver
    Excel 2016
    Posts
    15

    Re: Multiple workbooks into one workbook - asked to save or not save each workbook step re

    Thanks for the help Trebor76
    Reply With QuoteRegister To Reply
  7. 03-19-2014, 02:17 AM #7
    Benji Jeff
    Benji Jeff is offline
    Registered User
    Join Date
    03-19-2014
    Location
    Sydney
    MS-Off Ver
    Excel 2016
    Posts
    15

    Re: Multiple workbooks into one workbook - asked to save or not save each workbook step re

    Hi Robert

    I believe the code is properly tagged now, can you help ?

    Thanks
    Ben
    Reply With QuoteRegister To Reply
  8. 03-19-2014, 06:36 AM #8
    Trebor76
    Trebor76 is offline
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,523

    Re: Multiple workbooks into one workbook - asked to save or not save each workbook step re

    As you don't want to save on closing you just need to add to False to the end of Close statement i.e. from this code...

    Please Login or Register  to view this content.
    to this:

    Please Login or Register  to view this content.
    Regards,

    Robert
    Reply With QuoteRegister To Reply
  9. 03-20-2014, 04:30 PM #9
    Benji Jeff
    Benji Jeff is offline
    Registered User
    Join Date
    03-19-2014
    Location
    Sydney
    MS-Off Ver
    Excel 2016
    Posts
    15

    Re: Multiple workbooks into one workbook - asked to save or not save each workbook step re

    Hi Robert

    Thanks very much for your help with this

    Regards
    Ben
    Reply With QuoteRegister To Reply
  10. 03-20-2014, 09:48 PM #10
    Trebor76
    Trebor76 is offline
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,523

    Re: Multiple workbooks into one workbook - asked to save or not save each workbook step re

    No problem. If you could mark the thread as solved it would be appreciated.

    Robert
    Reply With QuoteRegister To Reply
  11. 03-20-2014, 09:54 PM #11
    Trebor76
    Trebor76 is offline
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,523

    Re: Multiple workbooks into one workbook - asked to save or not save each workbook step re

    No problem. If you could mark the thread as solved it would be appreciated.

    Robert
    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. [SOLVED] Save workbook, remove some worksheet code
    By D_N_L in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-26-2014, 08:51 AM
  2. [SOLVED] Save workbook as seperate workbooks
    By Floorplan in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-06-2013, 10:29 AM
  3. Add data from multiple workbooks that are open and save it in a new workbook
    By harry_b83 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2012, 03:14 AM
  4. remove all save options from just one workbook
    By 2funny4words in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-23-2009, 01:14 PM
  5. [SOLVED] Save Sheet and Remove from Workbook
    By South Bend Larry in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-18-2005, 01:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1