external file data

HI!

I have got 2 excel files

Eg
Data.xls and report.xls

I need to generate report from data.xls into Report.xls

is it possible that I run a macro look into "A CLOSED EXCEL FILE" and feed that data into another excel file.

Hope I am clear

Cheers
Nrupesh

[1651 byte] By [Nrupesh] at [2007-12-23]