Hello,
I'm quite new to VBA and also not sure whether the question which I'm going to ask can be done or not.
I've a folder in which there are 10 workbooks. What I want to do is to Extract data from all those 10 workbooks into a master workbook.
Now, I do not want those 10 workbooks to be opened for copying.
So I wanted to ask, is there a VBA code to copy the data from all those 10 workbooks present in the folder and paste it into the master workbook, without actually opening those 10 workbooks.
All the workbooks have 2 worksheets and I want to copy the data from only one worksheet. The data in all the workbooks will be in the same manner. The first row is header in all the workbooks and data will start from second row.
Note: all those 10 workbooks are made in MS Excel Version 2003.
I'm quite new to VBA and also not sure whether the question which I'm going to ask can be done or not.
I've a folder in which there are 10 workbooks. What I want to do is to Extract data from all those 10 workbooks into a master workbook.
Now, I do not want those 10 workbooks to be opened for copying.
So I wanted to ask, is there a VBA code to copy the data from all those 10 workbooks present in the folder and paste it into the master workbook, without actually opening those 10 workbooks.
All the workbooks have 2 worksheets and I want to copy the data from only one worksheet. The data in all the workbooks will be in the same manner. The first row is header in all the workbooks and data will start from second row.
Note: all those 10 workbooks are made in MS Excel Version 2003.