+ Reply to Thread
Results 1 to 2 of 2

Copy First Sheet of Multiple Workbooks in Folder to One Workbook

  1. #1
    Registered User
    Join Date
    05-24-2018
    Location
    Australia
    MS-Off Ver
    2013 Windows
    Posts
    16

    Copy First Sheet of Multiple Workbooks in Folder to One Workbook

    Hi,

    I would like to copy the first sheet only of multiple workbooks saved in a folder into one workbook using a macro.

    A few conditions:
    • The first sheet will have multiple names in these workbooks saved in the folder.
    • I would like it so the workbook the sheets will be copied into can be saved in the same folder so the source folder address doesn't have to be changed however if not possible / too hard not a problem. https://www.got-it.ai/solutions/exce...ne-excel-sheet This one is good because you can select the files in a dialogue however it copies every single sheet.
    • The workbook has these sheets all coped in as various sheets in the destination workbook. Not data all combined into one sheet in destination workbook.
    • I am using Excel 2013.

    I have tried a few codes I have found online and they don't seem to be working. For example I tried this one and no options given worked and the sheets themselves weren't even copied in.https://www.extendoffice.com/documen...workbooks.html I also tried https://www.excelforum.com/excel-pro...-workbook.html and the code in Post #5 but it also did not work.

    If anyone could help or at least point me in the right direction that would be greatly appreciated.

    Regards,
    GC
    Last edited by cavalieregiuseppe; 03-29-2021 at 10:31 PM. Reason: Add in another extra link

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,330

    Re: Copy First Sheet of Multiple Workbooks in Folder to One Workbook

    Just change file name to name you run this code from
    and file has to be in same map

    Please Login or Register  to view this content.
    Kind regards
    Leo

+ 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] Copy Range from multiple Workbooks in folder, to Summary Workbook also in same folder?
    By xlyfe in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-24-2018, 01:22 PM
  2. Replies: 9
    Last Post: 02-13-2015, 05:12 AM
  3. [SOLVED] Copy Same Sheet to Multiple Workbooks in Folder
    By allie14 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-02-2014, 10:13 AM
  4. Copy Sheet from one Workbook to Multiple Closed Workbooks
    By sflexi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2013, 10:01 AM
  5. Replies: 3
    Last Post: 10-24-2012, 06:41 AM
  6. copy & paste data from multiple workbooks to new workbook in a folder
    By Ignesh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-01-2012, 03:11 AM
  7. loop through workbooks in folder copy "jan" sheet into new workbook
    By Sirishgreen in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-27-2008, 06:00 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