Tech Support Guy banner
Status
Not open for further replies.
1 - 3 of 3 Posts

·
Registered
Joined
·
779 Posts
Discussion Starter · #1 ·
Hi, Im looking for some code examples so all users can all update an excel spreadsheet simultaneously (make changes/edit etc). Im having a little bit of difficulty finding documentation on this (how to's).

1. Each User would have their own copy of the original document
2. When a user makes a change, the form will update the master document in another directory.
3. This is to alleviate the problem of having multiple users only having access to the document, one user at a time.

Thanks for any good links/tips etc..

-t
 

·
Registered
Joined
·
21,398 Posts
Hi tjamnz,

Why not use a shared memory approach with one instance of the excel spreadsheet, and locks for each of the fields in the spreadsheet? Treat the spreadsheet essentially as a matrix data structure and lock each cell or (row, column) pair such that each user upon opening the excel spreadsheet accesses it with a different thread which is created when each user "opens" the spreadsheet - i.e. allow multiple reads, single synchronized writes using locks which each user's thread must acquire to update the cell (row, column) and release for another user to be able to refresh that cell with the latest update to it.

Give it more thought along those lines. Perhaps there is a simpler way to express this.

-- Tom
 
1 - 3 of 3 Posts
Status
Not open for further replies.
Top