Can you provide a link?
Do you think your VB code can be ported to Visual Basic For Applications=? I found several examples about using VBA for socket programming, but none is working.
For example,
Set Sock = New MSWinsockLib.winsock
raises an error as ActiveX can't create the object.
A very small VBA macro just using msgbox to show "Hello world" upon receiving something on port 80 would be enough for me to have something to start from. :-/