UserForm interacting with the Excel sheet saved on a local server

[Dan Tabla]

We are 5 people willing to working simultaneous (if possible) on a Excel
sheet saved on a local server. I need to type new informations in the
worksheet and sometimes to call a UserForm that will compile it and save back
the results.

I have basic knowledge with VBA, definetly not enough.
I would appreciate all the suggestions.

Thanks a lot and compile succesfully!

 

[ryguy7272]

http://www.exceladvisor.net/sub/creative/sharing.htm

http://office.microsoft.com/en-us/excel/HP052622941033.aspx

http://office.microsoft.com/en-us/excel/HA010130571033.aspx

but, be careful...
http://excel.tips.net/Pages/T002998_Losing_Data_in_a_Shared_Workbook.html

You may need this too:
http://hubpages.com/hub/Enter-Data-in-an-Excel-UserForm

If you're new to this, keep at it; you can do it. It's gonna take some work
though...

 

[joel]

Sharing workbooks is not recommended because excel is not reall
designed for sharing and conflicts can occur.


The prefered method is to store the data in an Access database. Yo
can create work excel workbook to be used as a front end to the databas
by quering the database from an excel workbook. You cn create userform
in the excel workbook where you can put changes to the database.

To store data into the database you can use connect to the database an
use the ADO method to write new data. All your macros can be in th
excel workbook. the storage need to be in an Access database to mak
sure you don't loose data when two people are accessing the storage fil
at the same time. Using excel you could loose data