yes filename is a subset of filepath i.e.

filepath = C:\File\workbook.xls
filename = workbook.xls

But i have found a workaround using ThisWorkbook.Workbook_Open() run
the macro when the workbook isn't opened manually. Any ideas how
could mke this conditional, i.e. somehow i could pass it a value an
depending on the value wether it would run or not? the value would hav
to be passed from the source macro

--
br_turnbul
-----------------------------------------------------------------------
br_turnbull's Profile: http://www.excelforum.com/member.php...fo&userid=2747
View this thread: http://www.excelforum.com/showthread.php?threadid=47873