View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
ann[_3_] ann[_3_] is offline
external usenet poster
 
Posts: 3
Default Able to open same excel workbook at the same time !

Thanks for your prompt replies Bob.
I realised that the solution lies in using the VBA. I was using Interop
till now.
I was able to check if the file is already open using VBA.FileOpen
method.