actually "Record" and "Sheet1" was used for hypothetical situation and
not a mistake.. thanks for pointing it out though.

I found out from Toms post in another thread that the workbook()
function cannot include paths of closed workbooks in VBA... so I guess
its a NO GO.


--
mattsvai
------------------------------------------------------------------------
mattsvai's Profile: http://www.excelforum.com/member.php...o&userid=31134
View this thread: http://www.excelforum.com/showthread...hreadid=508132