TCP/IP and Excel
 

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

--
Message posted from http://www.ExcelForum.com

TCP/IP and Excel
 

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

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Pyball " wrote in message
...
Working with Excel 2000 and Win NT 4.0

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

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

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


---
Message posted from http://www.ExcelForum.com/

TCP/IP and Excel
 

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')

--
Regards
Frank Kabel
Frankfurt, Germany

"Pyball " schrieb im
Newsbeitrag ...
Working with Excel 2000 and Win NT 4.0

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

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

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


---
Message posted from http://www.ExcelForum.com/

TCP/IP and Excel
 

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

--
Message posted from http://www.ExcelForum.com

TCP/IP and Excel
 

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

"Pyball " wrote in message
...
Rob, Frank,

Thank you for your replies.

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


---
Message posted from http://www.ExcelForum.com/