Hi,

I am working on a project which involves copying certain data from several
excel spreadsheets to a target excel spreadsheet. The source excel
spreadsheets are thousands in number and are formatted in a certain way so
that the cells can be specified for copying.

Opening and closing the source excel files is very tedious. Is there a way
to open an excel source file, copy the data to the target, kill the source
file and then repeat this process with the second source file till we
complete the entire set of excel source files using a macro?

"sharman" wrote:

Hi,

I am working on a project which involves copying certain data from several
excel spreadsheets to a target excel spreadsheet. The source excel
spreadsheets are thousands in number and are formatted in a certain way so
that the cells can be specified for copying.

Opening and closing the source excel files is very tedious. Is there a way
to open an excel source file, copy the data to the target, kill the source
file and then repeat this process with the second source file till we
complete the entire set of excel source files using a macro?



Certainly achievable using VBA but the specific code depends on how the data
to be copied out is structured, if the data structure differs between
workbooks and where the data is to be pasted in the main workbook.

Thanks for the reply. All the source excel sheets have data that is in 3
columns that start from row 18 and it certainly does not go beyond row 67. It
has to be pasted in the target excel sheet in the same format - in 3 columns.
The first source sheets's data goes in rows 1 thru 50 on the target sheet,
the second sheet's data starts from row 51 and ends in row 100 on the target
sheet and so forth.

"Matt Lunn" wrote:



"sharman" wrote:

Hi,

I am working on a project which involves copying certain data from several
excel spreadsheets to a target excel spreadsheet. The source excel
spreadsheets are thousands in number and are formatted in a certain way so
that the cells can be specified for copying.

Opening and closing the source excel files is very tedious. Is there a way
to open an excel source file, copy the data to the target, kill the source
file and then repeat this process with the second source file till we
complete the entire set of excel source files using a macro?



Certainly achievable using VBA but the specific code depends on how the data
to be copied out is structured, if the data structure differs between
workbooks and where the data is to be pasted in the main workbook.