{"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

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

<Coding Examples><\/h2>\n\n\n\n

The following is the simplest coding example.<\/p>\n\n\n\n

001 Set objXmlHttp = CreateObject(\"MSXML2.XMLHTTP\")\u3000\n002 objXmlHttp.Open \"GET\",\"<endpoint>\", False\n003 objXmlHttp.setRequestHeader \"X-Access-Key\", i_access_key\n004 objXmlHttp.send\n005 lStrResponse = objXmlHttp.responseText<\/code><\/pre>\n\n\n\n
001.Declare an object for http communication.<\/p>\n\n\n\n
If you get a compilation error, check that Micosoft XML X.X is referenced in the reference settings.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
002.Open communication to the destination.<\/p>\n\n\n\n
003.Write the request header. (Depends on the API specifications of the connection destination)<\/p>\n\n\n\n
004.Send the data. When sending using the POST method, set the parameters here. When using the GET method, set it to the endpoint’s query string.<\/p>\n\n\n\n
005.The return value from the destination computer\/server is stored in .responseText.<\/p>\n\n\n\n
Japan Immigration News<\/a><\/strong><\/h2>\n\n\n