Once that is sorted out, it’s pretty quick to cobble together a user interface to allow the user to initiate a connection and to send/receive data.īut I must confess that there is a little caveat as, althought I could successfully make a connection, I could not been able to pull any data back from my requests. The point here is to import Windows WinSock functions and defining the WinSock constants and data structures into the MS Office VBA environment. So if there is a locked-down sysadmin a port netcat to Microsoft Excel should come to the rescue. Netcat utility allows to open a network connection interactively, or to pipe the input/output of another program to a network socket, but in some office environment one may find the Windows version of netcat blocked by enterprise security software. This is an “abstract” from a post of Askur Corp, just keeping the interesting part of it: Following these interesting posts: the seed post, a question in MSDN forum, two Blogger Scott’s and Christophe’s (both similar, but Chistophe’s looks more evolved), and finally korean– japanese ones (no understanding of the chars…), should let get to a code to allow make GET/POST to any IP.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |