to get the path to the excelworkbook which is currently active you ca
use ..

homepath = ActiveWorkbook.Pat

--
jmoffa
-----------------------------------------------------------------------
jmoffat's Profile: http://www.excelforum.com/member.php...nfo&userid=115
View this thread: http://www.excelforum.com/showthread.php?threadid=48098