=C:\exampledirectory\[example.xls]Sheet1'!A1

Im not sure of what your asking but this code will find data from a closed
workbook and display it in your current workbook.

If this isn't what u want, can you explain again and I might be able to help
further


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200510/1