View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Keyur Keyur is offline
external usenet poster
 
Posts: 1
Default opening an excel file from another excel file

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