Hey EMoe, try this

Workbooks.open Filename:="I:\PLANT\LAB\Lab Tech Stuff\"
Range("A1").value

Merry Christmas,

Jaso

--
jt
-----------------------------------------------------------------------
jtp's Profile: http://www.excelforum.com/member.php...fo&userid=2113
View this thread: http://www.excelforum.com/showthread.php?threadid=49591