{"id":88,"date":"2024-01-01T06:53:47","date_gmt":"2023-12-31T21:53:47","guid":{"rendered":"https:\/\/www.japan-workers.com\/?p=88"},"modified":"2024-05-02T22:59:17","modified_gmt":"2024-05-02T13:59:17","slug":"internet-communication-via-excel-vba","status":"publish","type":"post","link":"https:\/\/www.japan-workers.com\/?p=88","title":{"rendered":"Internet via Excel VBA"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">HTTP communication is a typical method for exchanging data with external computers\/servers over the Internet. The coding is done using javascript, but it is also possible to write it using Excel VBA. The residence application management system used by the office: NICRAS also uses Excel VBA when transmitting residence application data using the Mynaportal API and when acquiring data from the NICRAS server.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">&lt;Coding Examples&gt;<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The following is the simplest coding example.<\/p>\n\n\n\n<pre class=\"wp-block-code has-dark-gray-background-color has-background\" style=\"font-size:13px\"><code>001 Set objXmlHttp = CreateObject(\"MSXML2.XMLHTTP\")\u3000\n002 objXmlHttp.Open \"GET\",\"&lt;endpoint&gt;\", False\n003 objXmlHttp.setRequestHeader \"X-Access-Key\", i_access_key\n004 objXmlHttp.send\n005 lStrResponse = objXmlHttp.responseText<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">001.Declare an object for http communication.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you get a compilation error, check that Micosoft XML X.X is referenced in the reference settings.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"726\" src=\"https:\/\/www.japan-workers.com\/wp-content\/uploads\/2024\/01\/\u753b\u50cf3-1024x726.png\" alt=\"\" class=\"wp-image-94\" srcset=\"https:\/\/www.japan-workers.com\/wp-content\/uploads\/2024\/01\/\u753b\u50cf3-1024x726.png 1024w, https:\/\/www.japan-workers.com\/wp-content\/uploads\/2024\/01\/\u753b\u50cf3-300x213.png 300w, https:\/\/www.japan-workers.com\/wp-content\/uploads\/2024\/01\/\u753b\u50cf3-768x545.png 768w, https:\/\/www.japan-workers.com\/wp-content\/uploads\/2024\/01\/\u753b\u50cf3.png 1122w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">002.Open communication to the destination.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">003.Write the request header. (Depends on the API specifications of the connection destination)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">004.Send the data. When sending using the POST method, set the parameters here. When using the GET method, set it to the endpoint&#8217;s query string.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">005.The return value from the destination computer\/server is stored in .responseText.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong><a href=\"http:\/\/ngj.jp\/press_manager.php?lang=ENG\" target=\"_blank\" rel=\"noopener nofollow\" title=\"\">Japan Immigration News<\/a><\/strong><\/h2>\n\n\n<ul class=\"is-grid columns-2 has-dates has-authors wp-block-rss\"><li class='wp-block-rss__item'><div class='wp-block-rss__item-title'><a href='https:\/\/www.unhcr.ca\/news\/refugees-in-yemen-trapped-between-conflict-displacement-and-dangerous-journeys\/'>Refugees in Yemen trapped between conflict, displacement and dangerous journeys<\/a><\/div><time datetime=\"2026-10-30T09:00:00+09:00\" class=\"wp-block-rss__item-publish-date\">2026-10-30<\/time> <span class=\"wp-block-rss__item-author\">by UNHCR<\/span><\/li><li class='wp-block-rss__item'><div class='wp-block-rss__item-title'><a href='https:\/\/japannews.yomiuri.co.jp\/politics\/politics-government\/20261029-356089\/'>Tightened Requirement for Permanent Residency in Japan Creating Concern on Effects on Labor Shortages<\/a><\/div><time datetime=\"2026-10-29T09:00:00+09:00\" class=\"wp-block-rss__item-publish-date\">2026-10-29<\/time> <span class=\"wp-block-rss__item-author\">by Japan News<\/span><\/li><li class='wp-block-rss__item'><div class='wp-block-rss__item-title'><a href='https:\/\/www.thedailystar.net\/news\/bangladesh\/news\/malaysia-bound-workers-may-leave-early-nov-4310326'>Malaysia-bound workers may leave from early Nov<\/a><\/div><time datetime=\"2026-10-29T09:00:00+09:00\" class=\"wp-block-rss__item-publish-date\">2026-10-29<\/time> <span class=\"wp-block-rss__item-author\">by The Daily Star<\/span><\/li><li class='wp-block-rss__item'><div class='wp-block-rss__item-title'><a href='https:\/\/www.asahi.com\/ajw\/articles\/17001720'>Police: Wealthy Chinese pay $600,000 to gain Japanese visa<\/a><\/div><time datetime=\"2026-10-28T09:00:00+09:00\" class=\"wp-block-rss__item-publish-date\">2026-10-28<\/time> <span class=\"wp-block-rss__item-author\">by The Asahi Shimbun<\/span><\/li><li class='wp-block-rss__item'><div class='wp-block-rss__item-title'><a href='https:\/\/www.openrightsgroup.org\/publications\/report-automated-discrimination-unpacking-the-digital-hostile-environment\/'>Report: Automated Discrimination: Unpacking the Digital Hostile Environment<\/a><\/div><time datetime=\"2026-10-27T09:00:00+09:00\" class=\"wp-block-rss__item-publish-date\">2026-10-27<\/time> <span class=\"wp-block-rss__item-author\">by Open Rights Group<\/span><\/li><li class='wp-block-rss__item'><div class='wp-block-rss__item-title'><a href='https:\/\/www.euronews.com\/2026\/10\/26\/exclusive-eu-to-give-frontex-new-powers-to-deport-migrants-from-outside-europe?utm_source=chatgpt.com'>Exclusive: EU to give Frontex new powers to deport migrants from outside Europe<\/a><\/div><time datetime=\"2026-10-26T09:00:00+09:00\" class=\"wp-block-rss__item-publish-date\">2026-10-26<\/time> <span class=\"wp-block-rss__item-author\">by euronews<\/span><\/li><li class='wp-block-rss__item'><div class='wp-block-rss__item-title'><a href='https:\/\/japannews.yomiuri.co.jp\/politics\/politics-government\/20261025-355356\/'>Japan\u2019s Immigration Services Agency to Use Digital Forensics to Seek Foreigners, Employers Involved in Illegal Work<\/a><\/div><time datetime=\"2026-10-25T09:00:00+09:00\" class=\"wp-block-rss__item-publish-date\">2026-10-25<\/time> <span class=\"wp-block-rss__item-author\">by Japan News<\/span><\/li><li class='wp-block-rss__item'><div class='wp-block-rss__item-title'><a href='https:\/\/calgaryherald.com\/opinion\/columnists\/opinion-alberta-now-has-opportunity-to-build-useful-immigration-program'>Opinion: Alberta now has opportunity to build useful immigration program<\/a><\/div><time datetime=\"2026-10-23T09:00:00+09:00\" class=\"wp-block-rss__item-publish-date\">2026-10-23<\/time> <span class=\"wp-block-rss__item-author\">by Calgary Herald<\/span><\/li><li class='wp-block-rss__item'><div class='wp-block-rss__item-title'><a href='https:\/\/www.upi.com\/Top_News\/World-News\/2026\/10\/23\/foreign-students-immigration-visa-overstays\/3961792786203\/'>Over 31,000 foreign students overstay visas in South Korea<\/a><\/div><time datetime=\"2026-10-23T09:00:00+09:00\" class=\"wp-block-rss__item-publish-date\">2026-10-23<\/time> <span class=\"wp-block-rss__item-author\">by United Press International<\/span><\/li><li class='wp-block-rss__item'><div class='wp-block-rss__item-title'><a href='https:\/\/apnews.com\/article\/trump-immigration-data-numbers-deportations-a550c554eea7d71deb00d92a0ba78677'>Deportations climb under Trump but fall short of White House target, a new report finds<\/a><\/div><time datetime=\"2026-10-23T09:00:00+09:00\" class=\"wp-block-rss__item-publish-date\">2026-10-23<\/time> <span class=\"wp-block-rss__item-author\">by AP News<\/span><\/li><\/ul>","protected":false},"excerpt":{"rendered":"<p>HTTP communication is a typical method for exchanging data with external computers\/servers over the Internet. The coding..<\/p>\n","protected":false},"author":1,"featured_media":125,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3,22,23],"tags":[],"class_list":["post-88","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-english","category-excel-vba","category-it-technology","entry"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.japan-workers.com\/index.php?rest_route=\/wp\/v2\/posts\/88","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.japan-workers.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.japan-workers.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.japan-workers.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.japan-workers.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=88"}],"version-history":[{"count":15,"href":"https:\/\/www.japan-workers.com\/index.php?rest_route=\/wp\/v2\/posts\/88\/revisions"}],"predecessor-version":[{"id":614,"href":"https:\/\/www.japan-workers.com\/index.php?rest_route=\/wp\/v2\/posts\/88\/revisions\/614"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.japan-workers.com\/index.php?rest_route=\/wp\/v2\/media\/125"}],"wp:attachment":[{"href":"https:\/\/www.japan-workers.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=88"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.japan-workers.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=88"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.japan-workers.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=88"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}