Not really you can use ado or xl4 macros... check out this link...

http://www.dailydoseofexcel.com/arch...ing-workbooks/
--
HTH...

Jim Thomlinson


"crazybass2" wrote:

Kev,

A file must be opened to read data from it.

Mike


"kev_06" wrote:


I'm trying to read values from a closed workbook. I'm using an If...
Then statement to analyze the values in the closed workbook and then
return a result in the current workbook. I've seen the code from Ron de
Bruin and on the website, but everything I find is not what I'm looking
for. I only need to read, not copy, values from a closed workbook. Is
it possible?


--
kev_06
------------------------------------------------------------------------
kev_06's Profile: http://www.excelforum.com/member.php...o&userid=35046
View this thread: http://www.excelforum.com/showthread...hreadid=561630