Hi alish

Take a look at the methods produced by Ron de Bruin
http://msdn.microsoft.com/en-us/library/cc793964.aspx

--
Regards
Roger Govier

"alish" wrote in message
...
Hi there. Can anyone help me in creating a VB code in excel Module that
imports data like file name;direct cost; and year from several xls
spreadsheets [reports_1, reports_2, ...] (from different sheets and cells)
into one spreadsheet [summary] into the following columns accordingly:
(column 1 [file name]: file name; column 2 [direct cost]: dollar amounts,
column 3 [year]: year)? i already have the code that pulls file names from
the folder directory and pastes the data into column 1 [file name]. may be
it
will be easier to have the code refer to that column 1. Please note that
the
Reports_1, Report_2, etc spreadsheets maintain the same formats and the
data
is ocated in the same cells (the same coordinates) and the same sheets
with
the same names. thanks in advance.

__________ Information from ESET Smart Security, version of virus
signature database 4780 (20100117) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4780 (20100117) __________

The message was checked by ESET Smart Security.

http://www.eset.com