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