Perhaps this will be more to your liking...

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

Jim Thomlinson


"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