{"id":23,"date":"2006-07-17T14:56:03","date_gmt":"2006-07-17T18:56:03","guid":{"rendered":"http:\/\/blogs.law.harvard.edu\/scaldwel\/2006\/07\/17\/socket-programming-in-vba\/"},"modified":"2006-07-17T14:56:19","modified_gmt":"2006-07-17T18:56:19","slug":"socket-programming-in-vba","status":"publish","type":"post","link":"https:\/\/archive.blogs.harvard.edu\/scaldwel\/2006\/07\/17\/socket-programming-in-vba\/","title":{"rendered":"Socket Programming in VBA"},"content":{"rendered":"<p>I recently spent many hours vainly searching online tech groups for code related to socket programming in Visual Basic for Applications (VBA) so that I could easily write VBA to enable tools developed in MS Excel or Access to &#8220;surf the web&#8221; to download data etc.  Finally, I found the following utility:<\/p>\n<p><span \/><a target=\"_blank\" href=\"http:\/\/www.ostrosoft.com\/oswinsck.asp#inst\">http:\/\/www.ostrosoft.com\/oswinsck.asp#inst<\/a><\/p>\n<p><a target=\"_blank\" href=\"http:\/\/blogs.law.harvard.edu\/scaldwel\/files\/2006\/07\/VBA_Sockets.txt\">This<\/a> code, when pasted into your &#8216;This Worksheet&#8217; object in the MS Excel VBA editor, for example, gets the raw html from a specified URL.  NB &#8211; to run this example you may need to add a reference to the OSWINSCKdll file in the VBA editor.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I recently spent many hours vainly searching online tech groups for code related to socket programming in Visual Basic for Applications (VBA) so that I could easily write VBA to enable tools developed in MS Excel or Access to &#8220;surf the web&#8221; to download data etc. Finally, I found the following utility: http:\/\/www.ostrosoft.com\/oswinsck.asp#inst This code, [&hellip;]<\/p>\n","protected":false},"author":268,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[142],"tags":[],"class_list":["post-23","post","type-post","status-publish","format-standard","hentry","category-technology"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/archive.blogs.harvard.edu\/scaldwel\/wp-json\/wp\/v2\/posts\/23","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/archive.blogs.harvard.edu\/scaldwel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/archive.blogs.harvard.edu\/scaldwel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/archive.blogs.harvard.edu\/scaldwel\/wp-json\/wp\/v2\/users\/268"}],"replies":[{"embeddable":true,"href":"https:\/\/archive.blogs.harvard.edu\/scaldwel\/wp-json\/wp\/v2\/comments?post=23"}],"version-history":[{"count":0,"href":"https:\/\/archive.blogs.harvard.edu\/scaldwel\/wp-json\/wp\/v2\/posts\/23\/revisions"}],"wp:attachment":[{"href":"https:\/\/archive.blogs.harvard.edu\/scaldwel\/wp-json\/wp\/v2\/media?parent=23"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/archive.blogs.harvard.edu\/scaldwel\/wp-json\/wp\/v2\/categories?post=23"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/archive.blogs.harvard.edu\/scaldwel\/wp-json\/wp\/v2\/tags?post=23"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}