Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save in Excel several users server | Excel Discussion (Misc queries) | |||
Run Excel file on a Server | Excel Discussion (Misc queries) | |||
Help - Automating a file.. Adding Users , Deleting users, Changing | Excel Worksheet Functions | |||
Create a xls File on Server without Excel? | Excel Programming | |||
Save Excel file at server? | Excel Programming |