Thanks Jim and Chip! That's what I love about this group. I always learn
something new.

Mike

"Chip Pearson" wrote:

A file must be opened to read data from it.

Not true. See my reply.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"crazybass2" wrote in
message
...
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