Sharing data on a worksheet over the internet?

P

Pyball

Hello Everyone,

I am using Excel 2000 and Windoes NT.

Multiple users are running a copy of the same workbook. These users ar
located in different buildings, with internet access. When a use
changes data on specific worksheet I want their changes to be reflecte
on the same worksheet on another users machine.

Example:

"User A" in building "A" changes data in cell "A1" of worksheet
"Status".

"User B" in Building "B" sees the changes in cell "A1" of worksheet
"Status" on their machine.

It would kind of be like collaboration over the internect but each use
would be using their own copy of the same workbook instead of makin
changes to a single workbook.

Is this possible using VBA or am I going to have to look to VB or C++?

Thanks in advance
 
D

David

For at least 2003, there a provision to track changes
from copies of the "same" workbook and then eith acept or
reject the changes individually. Never done it, only read
about it in "Excel 2003, Step by Step." This is written
by Microsoft Press, ISBN 0-7356-1518-7. It can track who,
what, when of changes in individual files and allow
a "master" to accept or eject the changes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top