Solved: need to multithread excel sheet so users can update/add data simultaneously

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

tjamnz

Thread Starter
Joined
Jun 15, 2004
Messages
775
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
 
Joined
Sep 12, 2003
Messages
20,583
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
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top