read data stream. from aaa.bbb.ccc.ddd port e in vba and convert to text file
Posted on 2014-01-17
Hi all knowing experts,
I have 4 PCs that are logging events and basically streaming these in text format from an ip address and a specific port. I would like another pc on same LAN to connect to each of these ports and create 4 expanding text files. After 24 hours I want to close each file and start again.
All of this needs to happen in vba if at all possible, although I am open to creating a vb project.
I have done some investigation around net and it seems there are a couple of ways to do this :
Cant remember if its udp or tcp transmission.
As stated this does not have to be particularly clever, just create a text file.
I have implemented a solution using telnet to file but my batch file is temperamental and I feel with vba in excel or word I can autoformat as it arrives making a much neater solution.
Most of the code I have seen seems to be too expansive, as stated I just want to replicate what telnet is doing.
Any pointers for a very simple listener really really appreciated.