{"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:\/\/inews.co.uk\/opinion\/polite-posh-revolt-exposing-britains-immigration-hypocrisy-4769204'>The polite, posh revolt exposing Britain\u2019s immigration hypocrisy<\/a><\/div><time datetime=\"2026-09-15T09:00:00+09:00\" class=\"wp-block-rss__item-publish-date\">2026-09-15<\/time> <span class=\"wp-block-rss__item-author\">by The i Paper<\/span><\/li><li class='wp-block-rss__item'><div class='wp-block-rss__item-title'><a href='https:\/\/edition.cnn.com\/2026\/09\/14\/us\/immigration-public-charge-green-card-lawsuits'>States sue to stop Trump rule that would make it harder for some immigrants to get green cards<\/a><\/div><time datetime=\"2026-09-14T09:00:00+09:00\" class=\"wp-block-rss__item-publish-date\">2026-09-14<\/time> <span class=\"wp-block-rss__item-author\">by CNN<\/span><\/li><li class='wp-block-rss__item'><div class='wp-block-rss__item-title'><a href='https:\/\/www.moroccoworldnews.com\/2026\/09\/338159\/over-5300-migrants-return-to-morocco-after-ceuta-mass-entry\/'>Over 5,300 Migrants Return to Morocco After Ceuta Mass Entry<\/a><\/div><time datetime=\"2026-09-13T09:00:00+09:00\" class=\"wp-block-rss__item-publish-date\">2026-09-13<\/time> <span class=\"wp-block-rss__item-author\">by Morocco World News<\/span><\/li><li class='wp-block-rss__item'><div class='wp-block-rss__item-title'><a href='https:\/\/www.sbs.com.au\/news\/article\/australias-debate-over-net-overseas-migration\/kobvomk3g'>Fixing Australia&#039;s immigration system is not just about cutting migrants<\/a><\/div><time datetime=\"2026-09-12T09:00:00+09:00\" class=\"wp-block-rss__item-publish-date\">2026-09-12<\/time> <span class=\"wp-block-rss__item-author\">by SBS News<\/span><\/li><li class='wp-block-rss__item'><div class='wp-block-rss__item-title'><a href='https:\/\/japan-forward.com\/immigration-enforcement-illegal-overstayers-cyber-patrols\/'>Japan Tightens Immigration Enforcement as Illegal Residency Fuels Public Unease<\/a><\/div><time datetime=\"2026-09-11T09:00:00+09:00\" class=\"wp-block-rss__item-publish-date\">2026-09-11<\/time> <span class=\"wp-block-rss__item-author\">by JAPAN Forward<\/span><\/li><li class='wp-block-rss__item'><div class='wp-block-rss__item-title'><a href='https:\/\/www.theguardian.com\/uk-news\/2026\/sep\/11\/asylum-seekers-removed-uk-to-france-disappeared-children-one-in-one-out'>Hundreds of asylum seekers removed from UK to France have disappeared, say NGOs<\/a><\/div><time datetime=\"2026-09-11T09:00:00+09:00\" class=\"wp-block-rss__item-publish-date\">2026-09-11<\/time> <span class=\"wp-block-rss__item-author\">by The Guardian<\/span><\/li><li class='wp-block-rss__item'><div class='wp-block-rss__item-title'><a href='https:\/\/www.euronews.com\/my-europe\/2026\/09\/10\/asylum-requests-in-europe-drop-to-five-year-low-in-first-half-of-2026'>Asylum requests in Europe drop to five-year low in first half of 2026<\/a><\/div><time datetime=\"2026-09-10T09:00:00+09:00\" class=\"wp-block-rss__item-publish-date\">2026-09-10<\/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\/20260909-347903\/'>Immigration Services Agency to Launch On-Site Checks for Unauthorized Foreign Workers<\/a><\/div><time datetime=\"2026-09-09T09:00:00+09:00\" class=\"wp-block-rss__item-publish-date\">2026-09-09<\/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.japantimes.co.jp\/news\/2026\/09\/09\/japan\/foreign-worker-category-aviation\/'>Immigration agency considering aviation category for foreign worker programs<\/a><\/div><time datetime=\"2026-09-09T09:00:00+09:00\" class=\"wp-block-rss__item-publish-date\">2026-09-09<\/time> <span class=\"wp-block-rss__item-author\">by Japan Times<\/span><\/li><li class='wp-block-rss__item'><div class='wp-block-rss__item-title'><a href='https:\/\/eastasiaforum.org\/2026\/09\/09\/how-japans-anti-immigration-politics-runs-on-imported-narratives\/'>How Japan\u2019s anti-immigration politics runs on imported narratives<\/a><\/div><time datetime=\"2026-09-09T09:00:00+09:00\" class=\"wp-block-rss__item-publish-date\">2026-09-09<\/time> <span class=\"wp-block-rss__item-author\">by EAST ASIA FORUM<\/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}]}}