hi
i figured it out i am defining a string path = activeworkbook.path
and then i am using
If Not WorkbookOpen("MyWorkbookName.xls") Then
Workbooks.Open path & "\MyWorkbookName.xls"
End If
thanks whoever read it and tried to help me
--
Message posted from
http://www.ExcelForum.com