Excel VBA opening of multiple excel file

[Jovillanueva]

Hi,

I have a requirements to open multiple excel file (3 different file). the contains of worksheet3 of these 3 diff files will be copied to my workingfile
under 3 different worksheet. May i ask your assistance on how to do this in excel vba or any idea. thank you in advance.

Sample of 3 multiple excel file that i would like to open. worksheet that i would like to copy is worksheet3
XLSample1.xls
XLSample2.xls
XLSample3.xls


My working file were to insert or copy the data that came from those 3 files. I wanted to copy the contains to sheet1 for XLSample1, sheet2 for XLSample2 and sheet3 for XLSample3.

MyDelivery.xlsm

Here is the sample macro code.

Please Login or Register  to view this content.

[mikeTRON]

Are you trying to create one worksheet that consolidates all three of the other workbooks?

[Jovillanueva]

Yes MikeTron.. I hav alrady an existing worksheet which i need to consolidate the 3 workbook.
Right now i have to create a button for every workbook to open and evaluate the content..
I wanted to use only 1 button and consolidate all those 3 workbook.

Sample:

MyWorkbook--- this is my mater workbook
MySample1 will dump into sheet2
MySample2 will dump into sheet3
MySample3 will dump into sheet4


--This is the workbook the i would like to copy the contents to MyWorkBook.
MySample1.xls---sheet2 data contents
MySample2.xls ---sheet1 data contents
MySample3.xls----sheet2 data contents