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?



  2. #2

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