Karinalex was thinking very hard :
I have multiple excel files (one for each type of contract), but I need
to submit a report listing all active contracts by parter company (plus
the names of each contract manager, the value, etc). Each partner
company has a code it is identified by, and I am looking for a way to
extract the info based on these codes. I am familiar with macros but not
programming. Is there a simple way to do this?

To answer your Q.., 'NO'! Whether you open each file and pull the
wanted data OR use ADODB to read the data from the files (without
opening them in Excel), the process will be fairly 'non-trivial'
because you're looking only to pull certain bits of info from the
source files.

I'd go with using ADODB because I can pull 'selective' data into a
recordset via my SQL statement and 'put' that into a worksheet where I
want it to appear.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion