Socket Programming in Excel
 

I have an excel workbook receiving real time data
and I would like to update it with a socket message from another programming.
How can I trigger the opening workbook to parse the data from the socket message, adding a record and save itself.