+ Reply to Thread
Results 1 to 3 of 3

VBA Excel Merge multiple workbooks

  1. #1
    Registered User
    Join Date
    10-24-2019
    Location
    London
    MS-Off Ver
    2010 and 2013
    Posts
    1

    VBA Excel Merge multiple workbooks

    Hi All,

    I have been researching online and found a piece of VBA code which I have edited to match my needs (working). The code is setup to look at a folder location and merge all excel .xlsx files into a master sheet. However, I am having difficulty amending the code to only read and copy a specific sheet from the source files. I only need to copy one specific sheet ("Sheet2") from each file :-). Appreciate the help:


    Please Login or Register  to view this content.
    Thanks
    Last edited by Pepe Le Mokko; 10-24-2019 at 11:14 AM.

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,128

    re: VBA Excel Merge multiple workbooks

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    I did it for you this time. Please read forum rules. Thanks
    Be very, very careful using IFERROR ! It hides ALL errors which is not always what you want to get correct results

  3. #3
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    5,124

    Arrow

    Hi !

    Quote Originally Posted by MXCG2016 View Post
    I only need to copy one specific sheet ("Sheet2") from each file
    If all workbooks have the same 'Sheet2' worksheet name with a same layout to import in a main workbook
    then there is a faster way in an one go than opening each workbook within Excel,
    so if you could attach 2/3 source samples workbooks and the expected result main workbook

+ 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. Merge multiple excel workbooks in to one Excel workbook
    By Kamalakar M in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-14-2016, 12:57 AM
  2. [SOLVED] Excel 2007 : Macro to merge multiple workbooks
    By trisoldee in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-13-2014, 03:18 PM
  3. Merge Multiple Excel Workbooks and Map Headers
    By mdrouin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-26-2013, 11:08 AM
  4. Merge Multiple Excel Workbooks with Macro
    By onmyway in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-18-2013, 06:56 AM
  5. How to merge multiple Excel workbooks into one file
    By mbogdanova in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-19-2012, 03:20 AM
  6. VBA to merge multiple Workbooks with multiple sheets retaining headers
    By LauraN1 in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 08-19-2010, 03:47 PM
  7. Replies: 3
    Last Post: 03-03-2010, 03:41 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1