Results 1 to 2 of 2

Thread: Combining Workbooks using VBa

  1. #1

    Combining Workbooks using VBa



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Guys.

    I need help with VBA code to combine workbooks.

    I have 14 workbooks named 1.00, 1.01, ... .., 1.13 in the following location/folder “C:\Users\user\Desktop\Excel”.

    Each workbook has One worksheet and I want to have a Master workbook containing all the worksheets from the 1.00 to 1.13 workbooks.

    To be specific, the Master workbook will contain the 14 worksheets and Each worksheet must be named Sheet0 to Sheet13. With Sheet0 corresponding to workbook 1.00, Sheet1 to workbook 1.01, etc

    How can I accomplish this with VBA or there are easier ways to do this?

    Thanks

    Jonah

  2. #2
    Acolyte patel's Avatar
    Join Date
    Feb 2014
    Location
    Italy
    Posts
    60
    Articles
    0
    Excel Version
    2010

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •