{"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:\/\/thehub.ca\/2026\/07\/31\/immigrants-adopting-canadas-record-low-fertility-patterns-western-researchers-find\/'>Immigrants adopting Canada\u2019s record-low fertility patterns, Western researchers find<\/a><\/div><time datetime=\"2026-07-31T09:00:00+09:00\" class=\"wp-block-rss__item-publish-date\">2026-07-31<\/time> <span class=\"wp-block-rss__item-author\">by The Hub<\/span><\/li><li class='wp-block-rss__item'><div class='wp-block-rss__item-title'><a href='https:\/\/www.japantimes.co.jp\/news\/2026\/07\/31\/japan\/japan-new-immigration-basic-plan\/'>Japan unveils new immigration plan focused on tighter regulations<\/a><\/div><time datetime=\"2026-07-31T09:00:00+09:00\" class=\"wp-block-rss__item-publish-date\">2026-07-31<\/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:\/\/mainichi.jp\/english\/articles\/20260729\/p2a\/00m\/0na\/016000c'>Shadows of hate, extremism hang over anti-immigration rally in Osaka<\/a><\/div><time datetime=\"2026-07-30T09:00:00+09:00\" class=\"wp-block-rss__item-publish-date\">2026-07-30<\/time> <span class=\"wp-block-rss__item-author\">by The Mainichi<\/span><\/li><li class='wp-block-rss__item'><div class='wp-block-rss__item-title'><a href='https:\/\/www.aljazeera.com\/news\/2026\/7\/30\/spanish-enclave-of-ceuta-raises-alarm-as-thousands-cross-morocco-border'>Spainish enclave Ceuta raises alarm as thousands cross border from Morocco<\/a><\/div><time datetime=\"2026-07-30T09:00:00+09:00\" class=\"wp-block-rss__item-publish-date\">2026-07-30<\/time> <span class=\"wp-block-rss__item-author\">by ALJAZEERA<\/span><\/li><li class='wp-block-rss__item'><div class='wp-block-rss__item-title'><a href='https:\/\/thehill.com\/opinion\/immigration\/5997071-stateless-protection-act-immigration-gap\/'>You can\u2019t go back to a country that doesn\u2019t exist<\/a><\/div><time datetime=\"2026-07-30T09:00:00+09:00\" class=\"wp-block-rss__item-publish-date\">2026-07-30<\/time> <span class=\"wp-block-rss__item-author\">by THE HILL<\/span><\/li><li class='wp-block-rss__item'><div class='wp-block-rss__item-title'><a href='https:\/\/europeanconservative.com\/articles\/news\/brussels-builds-continued-immigration-into-europes-future\/'>Brussels Builds Continued Immigration Into Europe\u2019s Future<\/a><\/div><time datetime=\"2026-07-30T09:00:00+09:00\" class=\"wp-block-rss__item-publish-date\">2026-07-30<\/time> <span class=\"wp-block-rss__item-author\">by The European Conservative<\/span><\/li><li class='wp-block-rss__item'><div class='wp-block-rss__item-title'><a href='https:\/\/thehill.com\/opinion\/immigration\/5995665-immigration-drives-housing-costs\/'>Deportation helps make affordability possible<\/a><\/div><time datetime=\"2026-07-29T09:00:00+09:00\" class=\"wp-block-rss__item-publish-date\">2026-07-29<\/time> <span class=\"wp-block-rss__item-author\">by THE HILL<\/span><\/li><li class='wp-block-rss__item'><div class='wp-block-rss__item-title'><a href='https:\/\/globalnation.inquirer.net\/332957\/answers-to-your-questions-about-koreas-digital-nomad-visa'>Answers to your questions about Korea\u2019s digital nomad visa<\/a><\/div><time datetime=\"2026-07-29T09:00:00+09:00\" class=\"wp-block-rss__item-publish-date\">2026-07-29<\/time> <span class=\"wp-block-rss__item-author\">by INQUIRER.net<\/span><\/li><li class='wp-block-rss__item'><div class='wp-block-rss__item-title'><a href='https:\/\/sp.m.jiji.com\/english\/show\/49258'>Japan to Boost Immigration Agency Staff by 226<\/a><\/div><time datetime=\"2026-07-28T09:00:00+09:00\" class=\"wp-block-rss__item-publish-date\">2026-07-28<\/time> <span class=\"wp-block-rss__item-author\">by JIJI PRESS<\/span><\/li><li class='wp-block-rss__item'><div class='wp-block-rss__item-title'><a href='https:\/\/www.theguardian.com\/uk-news\/2026\/jul\/28\/home-office-used-ai-hallucinated-information-to-refuse-asylum-claim-judge-suggests'>Home Office used \u2018AI hallucinated\u2019 information to refuse asylum claim, judge suggests<\/a><\/div><time datetime=\"2026-07-28T09:00:00+09:00\" class=\"wp-block-rss__item-publish-date\">2026-07-28<\/time> <span class=\"wp-block-rss__item-author\">by The Guardian<\/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}]}}