+ Reply to Thread
Results 1 to 3 of 3

VBA merge workbooks

  1. #1
    Forum Contributor
    Join Date
    10-31-2013
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    221

    VBA merge workbooks

    Hi I have multiple workbooks named for example H0_2016-07-01 so for each day of the month for every month, they all in the same file so I want to merge all the workbooks in this file into one one workbook called H0

    They all have "Controls" as the first worksheet then data on every sheet after this first sheet. I don't want to copy the "Controls" sheet from each file, I just want to copy all the other worksheets.

    Could any help with some VBA for this please?

  2. #2
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,343

    Re: VBA merge workbooks

    See if somethign here helps you

    http://www.rondebruin.nl/win/s3/win008.htm

    or maybe its as simple as this with some extra code to say ignore the control worksheet?

    http://www.vbaexpress.com/kb/getarticle.php?kb_id=221
    Last edited by scottiex; 08-07-2016 at 06:44 PM.

  3. #3
    Forum Contributor
    Join Date
    10-31-2013
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    221

    Re: VBA merge workbooks

    thanks scottiex that helped

+ 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. [SOLVED] How to merge workbooks
    By ammartino44 in forum Excel General
    Replies: 9
    Last Post: 01-16-2015, 04:00 PM
  2. [SOLVED] Merge All Workbooks
    By tejboyd in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-18-2014, 05:25 AM
  3. [SOLVED] Merge All Workbooks
    By tejboyd in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-23-2014, 11:55 AM
  4. Merge two workbooks
    By chasebattle in forum Excel General
    Replies: 10
    Last Post: 04-29-2010, 05:26 PM
  5. merge workbooks
    By aceblack10 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-30-2008, 03:36 PM
  6. [SOLVED] Trying to Merge 2 Workbooks
    By Anne in forum Excel General
    Replies: 2
    Last Post: 07-18-2006, 03:35 PM
  7. [SOLVED] merge workbooks
    By mg_sv_r in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-14-2006, 12:20 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