View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_14_] Bob Phillips[_14_] is offline
external usenet poster
 
Posts: 216
Default Able to open same excel workbook at the same time !

Surely, one of them will open it as read-only, thereby not being able to
write it back. You can test for this property.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"ann" wrote in message
ups.com...
Hi Everyone !
I m a newbie to excel programming but I noticed a bug (??) while
working with excel & VS.NET. I m able to open an excel workbook in 2
different instances of my application & I cant find a way to prevent
this from happening. As a result, 2 different users can , effectively
work on the same workbook, on a same worksheet & over-ride each other's
saves !!
Pls help if anyone has faced a similar problem & if there is anyway to
prevent this !

Thanks in advance
~Ann