Connect Excel via TCP/IP (Ethernet)

[Harald Klinger]

Hello!

If there is till someone who needs to connect VBA (e.g. Excel) to a LAN, just let me know!
I have recently created a quite small code which is doing that very well. You may use this code to transfer data of two excel sheets, both located on two different computers.

Regards, Harald

[Rabbit]

Could you post the code?

[Harald Klinger]

Yes, I will do this!
Is it also possible to post the entire excel sheet??
Don't know how do do this

Note: you need to pre-install the SocketWrench from Catalyst (its freeware!). Look here: http://www.catalyst.com/cgi-bin/down...i?product=6099


Harald

[hans Dohmen]

I need an option to get informations from the network (TCP-IP) into an excel sheet. I hope with your code to solve thie problem.
It is possible to get it.