For code to provide a flexible formula to extract data from a specified
cell in a closed file, refer:
http://www.excelforum.com/showthread.php?t=531126
http://www.dicks-blog.com/archives/2...ing-workbooks/
--
John James
------------------------------------------------------------------------
John James's Profile:
http://www.excelforum.com/member.php...o&userid=32690
View this thread:
http://www.excelforum.com/showthread...hreadid=526873