Many users for an Excel file in the server
 

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

Many users for an Excel file in the server
 

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

Many users for an Excel file in the server
 

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