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.
Note: all those 10 workbooks are made in MS Excel Version 2003.
Thanks in advance
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.
Note: all those 10 workbooks are made in MS Excel Version 2003.
Thanks in advance