In Excel 2000 there is a "Share Workbook" option. Under the "Tools" menu
option, select "Share Workbook..." and it will present you with a number of
options for this feature. One of the options under the "Editing" tab is
"Allow changes by more than one user at the same time". Note that this
feature needs to be turned off any time you are recording or editing macros,
so edit the macro and turn the feature back on when you are done.




"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