TCP Post via VBA

[tranchemontaigne]

I need to post simple strings (actually HL7 messages) to a remote server via a TCP post using a named IP address and designated port. My goal here is to do this natively, using VBA, rather than introduce 3rd party "helper" tools.

Composing the string is simple enough, but I am looking for some advice on how to create the socket and pass the data string.

I have MS Access 2010
I do not have access to dot net development tools

Any feedback would be appreciated, tips, or advice would be greatly appreciated.

 

[Uncle Gizmo]

This might be of interest ...

http://www.mrexcel.com/forum/excel-questions/633373-excel-communicate-using-tcp.html

Sent from my SM-G925F using Tapatalk

 

[tranchemontaigne]

Thanks for your help here. I was hoping there was a way to do this leveraging stock DLLs. This would be so much simplier if I could only use PERL....