TCP/IP and Excel

[Pyball]

Working with Excel 2000 and Win NT 4.0

Is there a way, maybe through API's, that I can enter data into m
workbook on my computer then have that data sent to another compute
over the internet and have it displayed in there workbook?

Basically I want to be able to have numerous people working with thei
own identical workbooks and have one sheet that displays the same dat
for everyone.

I have read through many books and searched the internet but haven'
been able to come up with anything

 

[Rob van Gelder]

Look at storing a central database, then use the External Data feature of
the Data menu

 

[Frank Kabel]

Hi
not really feasible with Excel. Though Excel suppports sharing
workbooks ('Tools - share') I'd recommend to solve this with a database
solution. You have to deal with the issue sccessing this database via
Internet.

for reporting purpose you may connect Excel to this database (using
'Data - Import External Data')

 

[Pyball]

Rob, Frank,

Thank you for your replies.

The central database is a feasable option. The only question now is ho
to connect to that database via the internet

 

[Robin Hammond]

It might be more complex than you want at this stage, but with SQL you can
connect to a remote server based on an IP address.

Robin Hammond
www.enhanceddatasystems.com