• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA code to Combine Workbook

B

BhuSan

New Member
Hi All,

I need a VBA code to combine all the files in a specific folder. Here is my situation,

1. Each workbook consist of sales from various region
2. I need to combine all the files into one workbook but each region sales as one sheet.
3. Name of the sheet should be the name of the Workbook.

Example:

I have two files ( A.xls and B.xls) in a folder called Test.
I need a third file called "Combined.xls" It should have two sheets named A and B respectively. In the sheet A it should have all the data what ever is there on file A. For sheet B also the same.

Please help me.

Thanks
Santhosh
 
You must log in or register to reply here.
Back
Top