Can a workbook variable be set by clicking the workbook?
 

Thanks Bob,

Looks like I'll have to do it this way then? The 'daily' file wil
always already be open so I thought there might be a way to referenc
it without re-opening?

Many thanks for your help anyway,

Regards,

Adria

--
Kobayash
-----------------------------------------------------------------------
Kobayashi's Profile: http://www.excelforum.com/member.php...info&userid=87
View this thread: http://www.excelforum.com/showthread.php?threadid=27331