If the users do not have to save the original workbook, but are allowed to
SaveAs, you may want to save the original as Read Only. This prevents the
conflict of users trying to save different changes at the same time. I have
an Excel workbook opened by a Visual Basic 6 application on a network;
multiple users can launch the same VB6 app to open the same workbook with no
difficulties.

Ed

"Tila" wrote in message
...
Hai,
I developped a logicel in Visual Basic, that calls a file
Excel calculate.xls,for some calculative informations.

My applications opens the file calculate.xls for inserting
and retreiving data from calculate.xls.

The probleme is 10 users use this logiciel and when one is
connected to this excel worksheet others could'nt.

For instant i copy the file excel in local directory of
each user so that each one work with their copy.

Is there any solution to avoid this probleme ?

Is it possible to work with just one copy of calculate.xls
for all users ?

If all wants to call it in the same time insert and
retreive data from excel file is it possible ?

Can anyone help me please.
Tila