{"id":11240,"date":"2019-02-18T15:00:23","date_gmt":"2019-02-18T06:00:23","guid":{"rendered":"https:\/\/www.ka-net.org\/blog\/?p=11240"},"modified":"2019-02-18T16:42:20","modified_gmt":"2019-02-18T07:42:20","slug":"google-docs-api%e3%82%92%e4%bd%bf%e3%81%a3%e3%81%a6google-%e3%83%89%e3%82%ad%e3%83%a5%e3%83%a1%e3%83%b3%e3%83%88%e3%82%92%e6%93%8d%e4%bd%9c%e3%81%99%e3%82%8bvba%e3%83%9e%e3%82%af%e3%83%ad","status":"publish","type":"post","link":"https:\/\/www.ka-net.org\/blog\/?p=11240","title":{"rendered":"Google Docs API\u3092\u4f7f\u3063\u3066Google \u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3092\u64cd\u4f5c\u3059\u308bVBA\u30de\u30af\u30ed"},"content":{"rendered":"<p>\u524d\u56de\u306e\u8a18\u4e8b\u3067\u65b0\u3057\u304f\u8ffd\u52a0\u3055\u308c\u305f<a href=\"https:\/\/developers.google.com\/docs\/api\/\" title=\"Google Docs API  |  Google Developers\" target=\"_blank\">Google Docs API<\/a>\u3092\u7d39\u4ecb\u3057\u307e\u3057\u305f\u3002<\/p>\n<div class=\"cardlink\"><a href=\"https:\/\/www.ka-net.org\/blog\/?p=11219\"><div class=\"cardlink_thumbnail\"><img src='https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/eyecatch-Google-120x120.png' alt='Google Docs API v1\u3092\u8a66\u3057\u3066\u307f\u307e\u3057\u305f\u3002' width=120 height=120 \/><\/a><\/div><div class=\"cardlink_content\"><span class=\"timestamp\">2019.02.14<\/span><div class=\"cardlink_title\"><a href=\"https:\/\/www.ka-net.org\/blog\/?p=11219\">Google Docs API v1\u3092\u8a66\u3057\u3066\u307f\u307e\u3057\u305f\u3002 <\/a><\/div><div class=\"cardlink_excerpt\">\u4e0b\u8a18TechCrunch\u306e\u8a18\u4e8b\u306b\u3088\u308b\u3068\u3001Google \u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306e\u65b0\u3057\u3044API\u304c\u4e00\u822c\u516c\u958b\u3055\u308c\u305f\u3068\u306e\u3053\u3068\u306a\u306e\u3067\u3001\u3055\u3063\u305d\u304f\u8a66\u3057\u3066\u307f\u307e\u3057\u305f\u3002\r\n\r\nGoogle\u306b\u3088\u308c\u3070\u3001\u30c7\u30d9\u30ed\u30c3\u30d1\u30fc\u306fREST API\u3092\u5229\u7528\u3057\u3066\u3001\u30e6\u30fc\u30b6\u30fc\u5411\u3051\u306e\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u81ea\u52d5\u5316\u306e\u30b5\u30fc\u30d3\u30b9\u3092\u8a2d\u8a08\u3057\u3001...<\/div><\/div><div class=\"cardlink_footer\"><\/div><\/div>\n<p>\u4eca\u56de\u306fDocs API\u3092VBA\u304b\u3089\u547c\u3073\u51fa\u3057\u3066\u3001\u65e2\u5b58\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306e\u60c5\u5831\u306e\u53d6\u5f97\u3084\u65b0\u898f\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306e\u4f5c\u6210\u3092\u884c\u3044\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n<h4 class=\"style4a\">\u5927\u307e\u304b\u306a\u51e6\u7406\u306e\u6d41\u308c<\/h4>\n<p>VBA\u304b\u3089Docs API\u3092\u547c\u3073\u51fa\u3059\u5834\u5408\u3001\u5927\u307e\u304b\u306a\u51e6\u7406\u306e\u6d41\u308c\u306f\u4e0b\u8a18\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<p>authorization code\u53d6\u5f97<br \/>\n\u2193<br \/>\naccess token\u53d6\u5f97<br \/>\n\u2193<br \/>\nAuthorization\u30d8\u30c3\u30c0\u30fc\u306baccess token\u3092\u542b\u3081\u3066API\u547c\u3073\u51fa\u3057<\/p>\n<p>\u4e00\u822c\u7684\u306aREST API\u306e\u547c\u3073\u51fa\u3057\u3068\u540c\u69d8\u3067\u3059\u306d\uff01<\/p>\n<h4 class=\"style4a\">\u30af\u30e9\u30a4\u30a2\u30f3\u30c8ID\u3068\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u30b7\u30fc\u30af\u30ec\u30c3\u30c8\u306e\u53d6\u5f97<\/h4>\n<p><span style=\"color: #ff0000; font-weight: bold;\">\u203b\u4e0b\u8a18\u624b\u9806\u306f 2019\/2\/18 \u6642\u70b9\u306e\u3082\u306e\u3067\u3059\u3002\u4eca\u5f8c\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u30a2\u30c3\u30d7\u306b\u3088\u3063\u3066\u3001\u753b\u9762\u3084\u624b\u9806\u304c\u5909\u66f4\u3055\u308c\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u306e\u3067\u3001\u305d\u306e\u70b9\u306f\u3054\u6ce8\u610f\u304f\u3060\u3055\u3044\u3002<\/span><\/p>\n<p>\u307e\u305a\u306fAPI\u306e\u547c\u3073\u51fa\u3057\u306b\u5fc5\u8981\u306a\u30af\u30e9\u30a4\u30a2\u30f3\u30c8ID\u3068\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u30b7\u30fc\u30af\u30ec\u30c3\u30c8\u3092\u53d6\u5f97\u3057\u307e\u3059\u3002<\/p>\n<ol>\n<li><a href=\"https:\/\/console.developers.google.com\/\" title=\"Google Developers Console\" target=\"_blank\">Google Developers Console<\/a>\u306b\u30a2\u30af\u30bb\u30b9\u3057\u3001Google \u30a2\u30ab\u30a6\u30f3\u30c8\u3067\u30ed\u30b0\u30a4\u30f3\u3057\u307e\u3059\u3002<\/li>\n<li>\u30c0\u30c3\u30b7\u30e5\u30dc\u30fc\u30c9\u753b\u9762\u304c\u8868\u793a\u3055\u308c\u308b\u306e\u3067\u3001\u300c<span style=\"color: #ff0000; font-weight: bold;\">\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u9078\u629e<\/span>\u300d\u304b\u3089\u300c<span style=\"color: #ff0000; font-weight: bold;\">\u65b0\u3057\u3044\u30d7\u30ed\u30b8\u30a7\u30af\u30c8<\/span>\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002\u65e2\u5b58\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u4f7f\u7528\u3057\u305f\u3044\u5834\u5408\u306f\u3001\u65b0\u3057\u3044\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3067\u306f\u306a\u304f\u65e2\u5b58\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/li>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_01.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_01.jpg\" alt=\"\" width=\"440\" height=\"89\" class=\"alignnone size-full wp-image-11241\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_01.jpg 440w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_01-300x61.jpg 300w\" sizes=\"auto, (max-width: 440px) 100vw, 440px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_02.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_02.jpg\" alt=\"\" width=\"796\" height=\"283\" class=\"alignnone size-full wp-image-11242\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_02.jpg 796w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_02-300x107.jpg 300w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_02-768x273.jpg 768w\" sizes=\"auto, (max-width: 796px) 100vw, 796px\" \/><\/a><\/p>\n<li>\u65b0\u3057\u3044\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u753b\u9762\u304c\u8868\u793a\u3055\u308c\u308b\u306e\u3067\u3001\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u540d\u3092\u5165\u529b\u3057\u3001\u300c<span style=\"color: #ff0000; font-weight: bold;\">\u4f5c\u6210<\/span>\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/li>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_03.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_03.jpg\" alt=\"\" width=\"583\" height=\"408\" class=\"alignnone size-full wp-image-11243\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_03.jpg 583w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_03-300x210.jpg 300w\" sizes=\"auto, (max-width: 583px) 100vw, 583px\" \/><\/a><\/p>\n<li>\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u304c\u4f5c\u6210\u3055\u308c\u305f\u3089\u3001\u4f5c\u6210\u3055\u308c\u305f\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u304c\u9078\u629e\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u3001\u300c<span style=\"color: #ff0000; font-weight: bold;\">\u30e9\u30a4\u30d6\u30e9\u30ea<\/span>\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/li>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_04.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_04.jpg\" alt=\"\" width=\"650\" height=\"246\" class=\"alignnone size-full wp-image-11244\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_04.jpg 650w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_04-300x114.jpg 300w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><\/a><\/p>\n<li>\u691c\u7d22\u30dc\u30c3\u30af\u30b9\u306b<i>\u201cdocs\u201d<\/i>\u3068\u5165\u529b\u3057\u3001\u7d50\u679c\u3068\u3057\u3066\u30d2\u30c3\u30c8\u3059\u308b\u300c<span style=\"color: #ff0000; font-weight: bold;\">Google Docs API<\/span>\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/li>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_05.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_05.jpg\" alt=\"\" width=\"779\" height=\"406\" class=\"alignnone size-full wp-image-11245\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_05.jpg 779w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_05-300x156.jpg 300w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_05-768x400.jpg 768w\" sizes=\"auto, (max-width: 779px) 100vw, 779px\" \/><\/a><\/p>\n<li>\u300c<span style=\"color: #ff0000; font-weight: bold;\">\u6709\u52b9\u306b\u3059\u308b<\/span>\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/li>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_06.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_06.jpg\" alt=\"\" width=\"654\" height=\"367\" class=\"alignnone size-full wp-image-11246\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_06.jpg 654w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_06-300x168.jpg 300w\" sizes=\"auto, (max-width: 654px) 100vw, 654px\" \/><\/a><\/p>\n<li>Google Docs AP\u753b\u9762\u304c\u8868\u793a\u3055\u308c\u308b\u306e\u3067\u3001\u300c<span style=\"color: #ff0000; font-weight: bold;\">\u8a8d\u8a3c\u60c5\u5831<\/span>\u300d\u304b\u3089\u300c<span style=\"color: #ff0000; font-weight: bold;\">\u8a8d\u8a3c\u60c5\u5831\u3092\u4f5c\u6210<\/span>\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/li>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_07.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_07.jpg\" alt=\"\" width=\"524\" height=\"334\" class=\"alignnone size-full wp-image-11247\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_07.jpg 524w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_07-300x191.jpg 300w\" sizes=\"auto, (max-width: 524px) 100vw, 524px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_08.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_08.jpg\" alt=\"\" width=\"795\" height=\"301\" class=\"alignnone size-full wp-image-11248\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_08.jpg 795w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_08-300x114.jpg 300w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_08-768x291.jpg 768w\" sizes=\"auto, (max-width: 795px) 100vw, 795px\" \/><\/a><\/p>\n<li>\u4f7f\u7528\u3059\u308bAPI\u306f\u300c<span style=\"color: #ff0000; font-weight: bold;\">Google Docs AP<\/span>\u300d\u3001API\u3092\u547c\u3073\u51fa\u3059\u5834\u6240\u306f\u300c<span style=\"color: #ff0000; font-weight: bold;\">\u305d\u306e\u4ed6\u306eUI (Windows\u3001 CLI \u30c4\u30fc\u30eb\u306a\u3069)<\/span>\u300d\u3001\u30a2\u30af\u30bb\u30b9\u3059\u308b\u30c7\u30fc\u30bf\u306e\u7a2e\u985e\u306f\u300c<span style=\"color: #ff0000; font-weight: bold;\">\u30e6\u30fc\u30b6\u30fc\u30c7\u30fc\u30bf<\/span>\u300d\u3092\u9078\u629e\u3057\u3001\u300c<span style=\"color: #ff0000; font-weight: bold;\">\u5fc5\u8981\u306a\u8a8d\u8a3c\u60c5\u5831<\/span>\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/li>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_09.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_09.jpg\" alt=\"\" width=\"936\" height=\"622\" class=\"alignnone size-full wp-image-11249\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_09.jpg 936w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_09-300x199.jpg 300w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_09-768x510.jpg 768w\" sizes=\"auto, (max-width: 936px) 100vw, 936px\" \/><\/a><\/p>\n<li>\u9069\u5f53\u306aOAuth\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u540d\u3092\u5165\u529b\u3057\u3001\u300c<span style=\"color: #ff0000; font-weight: bold;\">OAuth \u30af\u30e9\u30a4\u30a2\u30f3\u30c8 ID\u3092\u4f5c\u6210<\/span>\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/li>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_10.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_10.jpg\" alt=\"\" width=\"813\" height=\"351\" class=\"alignnone size-full wp-image-11250\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_10.jpg 813w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_10-300x130.jpg 300w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_10-768x332.jpg 768w\" sizes=\"auto, (max-width: 813px) 100vw, 813px\" \/><\/a><\/p>\n<li>OAuth 2.0 \u540c\u610f\u753b\u9762\u306e\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u3068\u30e6\u30fc\u30b6\u30fc\u306b\u8868\u793a\u3059\u308b\u30b5\u30fc\u30d3\u30b9\u540d\u3092\u5165\u529b\u3057\u3001\u300c<span style=\"color: #ff0000; font-weight: bold;\">\u6b21\u3078<\/span>\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/li>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_11.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_11.jpg\" alt=\"\" width=\"683\" height=\"517\" class=\"alignnone size-full wp-image-11251\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_11.jpg 683w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_11-300x227.jpg 300w\" sizes=\"auto, (max-width: 683px) 100vw, 683px\" \/><\/a><\/p>\n<li>\u30af\u30e9\u30a4\u30a2\u30f3\u30c8ID\u304c\u8868\u793a\u3055\u308c\u305f\u3089\u300c<span style=\"color: #ff0000; font-weight: bold;\">\u5b8c\u4e86<\/span>\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/li>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_12.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_12.jpg\" alt=\"\" width=\"983\" height=\"555\" class=\"alignnone size-full wp-image-11252\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_12.jpg 983w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_12-300x169.jpg 300w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_12-768x434.jpg 768w\" sizes=\"auto, (max-width: 983px) 100vw, 983px\" \/><\/a><\/p>\n<li>\u8a8d\u8a3c\u60c5\u5831\u753b\u9762\u304b\u3089\u3001\u4f5c\u6210\u3057\u305f\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u306e\u300c<span style=\"color: #ff0000; font-weight: bold;\">OAuth \u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u3092\u7de8\u96c6<\/span>\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/li>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_13.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_13.jpg\" alt=\"\" width=\"1280\" height=\"409\" class=\"alignnone size-full wp-image-11253\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_13.jpg 1280w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_13-300x96.jpg 300w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_13-768x245.jpg 768w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_13-1024x327.jpg 1024w\" sizes=\"auto, (max-width: 1280px) 100vw, 1280px\" \/><\/a><\/p>\n<li>\u30af\u30e9\u30a4\u30a2\u30f3\u30c8ID\u3068\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u30b7\u30fc\u30af\u30ec\u30c3\u30c8\u304c\u8868\u793a\u3055\u308c\u308b\u306e\u3067\u3001\u30e1\u30e2\u5e33\u306a\u3069\u306e\u30c6\u30ad\u30b9\u30c8\u30a8\u30c7\u30a3\u30bf\u306b\u30b3\u30d4\u30fc\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/li>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_14.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_14.jpg\" alt=\"\" width=\"798\" height=\"353\" class=\"alignnone size-full wp-image-11254\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_14.jpg 798w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_14-300x133.jpg 300w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_14-768x340.jpg 768w\" sizes=\"auto, (max-width: 798px) 100vw, 798px\" \/><\/a>\n<\/ol>\n<h4 class=\"style4a\">Google Docs API\u3092\u4f7f\u3063\u3066Google \u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3092\u64cd\u4f5c\u3059\u308bVBA\u30de\u30af\u30ed<\/h4>\n<p>\u4e0b\u6e96\u5099\u304c\u3067\u304d\u305f\u306e\u3067\u5b9f\u969b\u306b\u30b3\u30fc\u30c9\u3092\u66f8\u3044\u3066\u3044\u304d\u307e\u3059\u3002<br \/>\n\u8a8d\u8a3c\u51e6\u7406\u306a\u3069\u3001\u8a73\u3057\u3044\u51e6\u7406\u306e\u6d41\u308c\u306f<a href=\"https:\/\/developers.google.com\/identity\/protocols\/OAuth2InstalledApp?hl=ja\" title=\"OAuth 2.0 for Mobile &#038; Desktop Apps  |  Google Identity Platform  |  Google Developers\" target=\"_blank\">Google Developers \u30ac\u30a4\u30c9<\/a>\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>\u4e0b\u8a18\u30b3\u30fc\u30c9\u306fScriptControl\u3092\u4f7f\u7528\u3057\u3066\u3044\u308b\u305f\u3081\u300164\u30d3\u30c3\u30c8\u7248\u306eOffice\u3067\u306f\u52d5\u4f5c\u3057\u307e\u305b\u3093\u3002<br \/>\n\u307e\u305f\u3001\u5b9f\u884c\u3059\u308b\u969b\u306f\u30b3\u30fc\u30c9\u4e2d\u306eclient_id\u3001client_secret\u3001document_id\u3092\u66f8\u304d\u63db\u3048\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<pre class=\"brush: vb; title: ; notranslate\" title=\"\">Option Explicit\r\n\r\n'--------------------------------------------------\r\n'\u203b \u8981\u5909\u66f4\r\n'--------------------------------------------------\r\nPrivate Const client_id As String = &quot;(\u30af\u30e9\u30a4\u30a2\u30f3\u30c8ID)&quot;\r\nPrivate Const client_secret As String = &quot;(\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u30b7\u30fc\u30af\u30ec\u30c3\u30c8)&quot;\r\nPrivate Const document_id As String = &quot;(\u60c5\u5831\u3092\u53d6\u5f97\u3057\u305f\u3044\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306eID)&quot;\r\n'--------------------------------------------------\r\nPrivate Const redirect_uri As String = &quot;urn:ietf:wg:oauth:2.0:oob&quot;\r\n\r\nPublic Sub CallGoogleDocsAPI()\r\n'Google Docs API v1\u306e\u547c\u3073\u51fa\u3057\r\n  Dim access_token As String\r\n  Dim json_str As String\r\n  Dim new_document_id As String\r\n  Dim sc As Object\r\n  Dim json As Object\r\n  Dim req As Object\r\n  Dim dat As Variant\r\n  Const request_base_url As String = &quot;https:\/\/docs.googleapis.com\/v1\/documents&quot;\r\n  \r\n  access_token = GetAccessToken\r\n  If Len(Trim(access_token)) &gt; 0 Then\r\n    Set req = CreateObject(&quot;WinHttp.WinHttpRequest.5.1&quot;)\r\n    Set sc = CreateObject(&quot;ScriptControl&quot;)\r\n    sc.Language = &quot;JScript&quot;\r\n    \r\n    '\u6307\u5b9a\u3057\u305f\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306e\u30bf\u30a4\u30c8\u30eb\u53d6\u5f97\r\n    With req\r\n      .Open &quot;GET&quot;, request_base_url &amp; &quot;\/&quot; &amp; document_id, False\r\n      .SetRequestHeader &quot;Content-Type&quot;, &quot;application\/json; charset=UTF-8&quot;\r\n      .SetRequestHeader &quot;Authorization&quot;, &quot;Bearer &quot; &amp; access_token\r\n      .Send\r\n      Select Case .Status\r\n        Case 200\r\n          json_str = &quot;(&quot; &amp; .responseText &amp; &quot;)&quot;\r\n          Set json = sc.CodeObject.eval(json_str)\r\n          Debug.Print &quot;\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306e\u30bf\u30a4\u30c8\u30eb\uff1a&quot; &amp; VBA.CallByName(json, &quot;title&quot;, VbGet)\r\n      End Select\r\n    End With\r\n    \r\n    '\u65b0\u898f\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306e\u4f5c\u6210\r\n    With req\r\n      dat = &quot;{&quot;&quot;title&quot;&quot;: &quot;&quot;API\u304b\u3089\u4f5c\u6210\u3057\u305f\u6587\u66f8&quot;&quot;}&quot; '\u30bf\u30a4\u30c8\u30eb\u8a2d\u5b9a\r\n      .Open &quot;POST&quot;, request_base_url, False\r\n      .SetRequestHeader &quot;Content-Type&quot;, &quot;application\/json; charset=UTF-8&quot;\r\n      .SetRequestHeader &quot;Authorization&quot;, &quot;Bearer &quot; &amp; access_token\r\n      .Send dat\r\n      Select Case .Status\r\n        Case 200\r\n          json_str = &quot;(&quot; &amp; .responseText &amp; &quot;)&quot;\r\n          Set json = sc.CodeObject.eval(json_str)\r\n          new_document_id = VBA.CallByName(json, &quot;documentId&quot;, VbGet)\r\n      End Select\r\n    End With\r\n    \r\n    '\u6587\u5b57\u5217\u306e\u633f\u5165\r\n    If Len(Trim(new_document_id)) &gt; 0 Then\r\n      With req\r\n        dat = &quot;{&quot;&quot;requests&quot;&quot;:&#x5B;{&quot;&quot;insertText&quot;&quot;:{&quot;&quot;location&quot;&quot;:{&quot;&quot;index&quot;&quot;:1},&quot;&quot;text&quot;&quot;:&quot;&quot;\u3053\u3093\u306b\u3061\u306f\u3001\u4e16\u754c\uff01&quot;&quot;}}]}&quot; '\u633f\u5165\u3059\u308b\u6587\u5b57\u5217\u8a2d\u5b9a\r\n        .Open &quot;POST&quot;, request_base_url &amp; &quot;\/&quot; &amp; new_document_id &amp; &quot;:batchUpdate&quot;, False\r\n        .SetRequestHeader &quot;Content-Type&quot;, &quot;application\/json; charset=UTF-8&quot;\r\n        .SetRequestHeader &quot;Authorization&quot;, &quot;Bearer &quot; &amp; access_token\r\n        .Send dat\r\n        Select Case .Status\r\n          Case 200\r\n            Debug.Print &quot;\u65b0\u898f\u4f5c\u6210\u3057\u305f\u6587\u66f8(\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8ID\uff1a&quot; &amp; new_document_id &amp; &quot;)\u3078\u306e\u6587\u5b57\u5217\u633f\u5165\u304c\u6210\u529f\u3057\u307e\u3057\u305f\u3002&quot;\r\n        End Select\r\n      End With\r\n    End If\r\n  End If\r\nEnd Sub\r\n\r\nPrivate Function GetAccessToken() As String\r\n'access token\u53d6\u5f97\r\n  Dim auth_code As String\r\n  Dim access_token As String\r\n  Dim json_str As String\r\n  Dim sc As Object\r\n  Dim json As Object\r\n  Dim dat As Variant\r\n  Const token_base_url As String = &quot;https:\/\/accounts.google.com\/o\/oauth2\/token&quot;\r\n  Const grant_type As String = &quot;authorization_code&quot;\r\n  \r\n  auth_code = GetAuthorizationCode\r\n  If Len(Trim(auth_code)) &gt; 0 Then\r\n    dat = &quot;code=&quot; &amp; auth_code &amp; &quot;&amp;&quot; &amp; _\r\n          &quot;client_id=&quot; &amp; client_id &amp; &quot;&amp;&quot; &amp; _\r\n          &quot;client_secret=&quot; &amp; client_secret &amp; &quot;&amp;&quot; &amp; _\r\n          &quot;redirect_uri=&quot; &amp; redirect_uri &amp; &quot;&amp;&quot; &amp; _\r\n          &quot;grant_type=&quot; &amp; grant_type\r\n    With CreateObject(&quot;WinHttp.WinHttpRequest.5.1&quot;)\r\n      .Open &quot;POST&quot;, token_base_url, False\r\n      .SetRequestHeader &quot;Content-Type&quot;, &quot;application\/x-www-form-urlencoded;charset=UTF-8&quot;\r\n      .Send dat\r\n      Select Case .Status\r\n        Case 200\r\n          Set sc = CreateObject(&quot;ScriptControl&quot;)\r\n          sc.Language = &quot;JScript&quot;\r\n          json_str = &quot;(&quot; &amp; .responseText &amp; &quot;)&quot;\r\n          Set json = sc.CodeObject.eval(json_str)\r\n          access_token = VBA.CallByName(json, &quot;access_token&quot;, VbGet)\r\n      End Select\r\n    End With\r\n  End If\r\n  GetAccessToken = access_token\r\nEnd Function\r\n\r\nPrivate Function GetAuthorizationCode() As String\r\n'authorization code\u53d6\u5f97\r\n  Dim url_auth As String\r\n  Dim approval_title As String\r\n  Dim code As String\r\n  Dim scopes As Variant\r\n  Dim ary As Variant, ary2 As Variant\r\n  Dim i As Long\r\n  Const READYSTATE_COMPLETE = 4\r\n  Const auth_base_url As String = &quot;https:\/\/accounts.google.com\/o\/oauth2\/auth&quot;\r\n  Const approval_url As String = &quot;https:\/\/accounts.google.com\/o\/oauth2\/approval\/&quot;\r\n  Const response_type As String = &quot;code&quot;\r\n  \r\n  '\u30b9\u30b3\u30fc\u30d7\u8a2d\u5b9a\r\n  scopes = Array(&quot;https:\/\/www.googleapis.com\/auth\/drive&quot;, _\r\n                 &quot;https:\/\/www.googleapis.com\/auth\/documents&quot;)\r\n  \r\n  url_auth = auth_base_url &amp; &quot;?redirect_uri=&quot; &amp; EncodeURL(redirect_uri) &amp; _\r\n             &quot;&amp;client_id=&quot; &amp; client_id &amp; _\r\n             &quot;&amp;response_type=&quot; &amp; response_type &amp; _\r\n             &quot;&amp;scope=&quot; &amp; EncodeURL(Join(scopes, &quot; &quot;))\r\n  \r\n  With CreateObject(&quot;InternetExplorer.Application&quot;)\r\n    .Visible = True\r\n    .AddressBar = False\r\n    .MenuBar = False\r\n    .StatusBar = False\r\n    .Toolbar = False\r\n    .Width = 600\r\n    .Height = 480\r\n    .Navigate url_auth\r\n    While .ReadyState &lt;&gt; READYSTATE_COMPLETE Or _\r\n          .Busy = True Or _\r\n          (StrComp(Left(.LocationURL, Len(approval_url)), approval_url) &lt;&gt; 0)\r\n      DoEvents\r\n    Wend\r\n    approval_title = .document.Title\r\n    .Quit\r\n  End With\r\n  \r\n  If InStr(approval_title, &quot;Success &quot;) Then\r\n    approval_title = Replace(approval_title, &quot;Success &quot;, &quot;&quot;)\r\n    ary = Split(approval_title, &quot;&amp;&quot;)\r\n    For i = LBound(ary) To UBound(ary)\r\n      ary2 = Split(ary(i), &quot;=&quot;)\r\n      If LCase(ary2(0)) = &quot;code&quot; Then\r\n        code = ary2(1)\r\n        Exit For\r\n      End If\r\n    Next\r\n  End If\r\n  GetAuthorizationCode = code\r\nEnd Function\r\n\r\nPrivate Function EncodeURL(ByVal str As String) As String\r\n'URL\u30a8\u30f3\u30b3\u30fc\u30c9\r\n  With CreateObject(&quot;ScriptControl&quot;)\r\n    .Language = &quot;JScript&quot;\r\n    EncodeURL = .CodeObject.encodeURIComponent(str)\r\n  End With\r\nEnd Function<\/pre>\n<h4 class=\"style4a\">\u5b9f\u884c\u7d50\u679c<\/h4>\n<p>\u4e0a\u8a18\u30b3\u30fc\u30c9(CallGoogleDocsAPI)\u3092\u5b9f\u884c\u3057\u3001\u554f\u984c\u306a\u304fAPI\u306e\u547c\u3073\u51fa\u3057\u304c\u884c\u308f\u308c\u308b\u3068\u3001\u6307\u5b9a\u3057\u305f\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306e\u30bf\u30a4\u30c8\u30eb\u306e\u53d6\u5f97(<a href=\"https:\/\/developers.google.com\/docs\/api\/reference\/rest\/v1\/documents\/get\" title=\"Method: documents.get  |  Google Docs API  |  Google Developers\" target=\"_blank\">documents.get<\/a>)\u3068\u3001\u65b0\u898f\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306e\u4f5c\u6210(<a href=\"https:\/\/developers.google.com\/docs\/api\/reference\/rest\/v1\/documents\/create\" title=\"Method: documents.create  |  Google Docs API  |  Google Developers\" target=\"_blank\">documents.create<\/a>)\u3001\u53ca\u3073\u6587\u5b57\u5217\u306e\u633f\u5165(<a href=\"https:\/\/developers.google.com\/docs\/api\/reference\/rest\/v1\/documents\/batchUpdate\" title=\"Method: documents.batchUpdate  |  Google Docs API  |  Google Developers\" target=\"_blank\">documents.batchUpdate<\/a>)\u304c\u884c\u308f\u308c\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_15.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_15.jpg\" alt=\"\" width=\"823\" height=\"147\" class=\"alignnone size-full wp-image-11255\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_15.jpg 823w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_15-300x54.jpg 300w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_15-768x137.jpg 768w\" sizes=\"auto, (max-width: 823px) 100vw, 823px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_16.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_16.jpg\" alt=\"\" width=\"767\" height=\"380\" class=\"alignnone size-full wp-image-11256\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_16.jpg 767w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/GoogleDocsAPIv1_02_16-300x149.jpg 300w\" sizes=\"auto, (max-width: 767px) 100vw, 767px\" \/><\/a><\/p>\n<p>Docs API\u3092\u4f7f\u3063\u3066\u5177\u4f53\u7684\u306b\u3069\u306e\u3088\u3046\u306a\u51e6\u7406\u304c\u3067\u304d\u308b\u306e\u304b\u306f\u3001<a href=\"https:\/\/developers.google.com\/docs\/api\/reference\/rest\/\" title=\"Google Docs API  |  Google Docs API  |  Google Developers\" target=\"_blank\">\u516c\u5f0f\u306e\u30ea\u30d5\u30a1\u30ec\u30f3\u30b9<\/a>\u3092\u898b\u308b\u3068\u826f\u3044\u3067\u3057\u3087\u3046\u3002<\/p>\n<div id=\"single_banner_area2\" class=\"clearfix one_banner\">\n<div class=\"single_banner single_banner_left\">\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\r\n<!-- \u8a18\u4e8b\u4e2d(\u30c7\u30a3\u30b9\u30d7\u30ec\u30a4\u5e83\u544a\u30e6\u30cb\u30c3\u30c8) -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-client=\"ca-pub-7306936664602087\"\r\n     data-ad-slot=\"5429724765\"\r\n     data-ad-format=\"auto\"\r\n     data-full-width-responsive=\"true\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<div class=\"single_banner single_banner_right\">\n<a href=\"\" target=\"_blank\"><img decoding=\"async\" src=\"\" alt=\"\" title=\"\" \/><\/a>\n<\/div>\n<\/div>\n\n<h4 class=\"style4a\">\u304a\u308f\u308a\u306b<\/h4>\n<p>API\u306e\u547c\u3073\u51fa\u3057\u306fJSON\u3067\u3084\u308a\u53d6\u308a\u3059\u308b\u3053\u3068\u306b\u306a\u308b\u306e\u3067\u3001\u4e0a\u8a18\u30b3\u30fc\u30c9\u3092\u898b\u308c\u3070\u5206\u304b\u308b\u901a\u308a\u3001\u7d20\u306eVBA\u3067\u306f\u51e6\u7406\u304c\u975e\u5e38\u306b\u5197\u9577\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<p>\u8a8d\u8a3c\u542b\u3081\u3066\u3001\u3044\u3061\u3044\u3061\u9762\u5012\u304f\u3055\u3044\u51e6\u7406\u3092\u884c\u308f\u306a\u3051\u308c\u3070\u306a\u3089\u306a\u3044\u306e\u3067\u3001\u79c1\u500b\u4eba\u3068\u3057\u3066\u306f<span style=\"color: #ff0000; font-weight: bold;\">VBA\u304b\u3089\u306eAPI\u547c\u3073\u51fa\u3057\u306f\u6b63\u76f4\u304a\u85a6\u3081\u3057\u307e\u305b\u3093<\/span>&#x1f605;<\/p>\n<p>\u305f\u3060\u5358\u306bAPI\u3092\u8a66\u3057\u305f\u3044\u3060\u3051\u3067\u3042\u308c\u3070\u3001\u7d20\u76f4\u306b<a href=\"https:\/\/developers.google.com\/apis-explorer\/\" title=\"Google APIs Explorer\" target=\"_blank\">Google APIs Explorer<\/a>\u3092\u4f7f\u3046\u3053\u3068\u3092\u304a\u85a6\u3081\u3057\u307e\u3059\u3002<\/p>\n<h4 class=\"style4a\">\u95a2\u9023\u8a18\u4e8b<\/h4>\n<div class=\"cardlink\"><a href=\"https:\/\/www.ka-net.org\/blog\/?p=4524\"><div class=\"cardlink_thumbnail\"><img src='https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/eyecatch-Excel-120x120.png' alt='Gmail API\u3092\u4f7f\u3063\u3066\u30e1\u30fc\u30eb\u9001\u4fe1\u3059\u308bVBA\u30de\u30af\u30ed' width=120 height=120 \/><\/a><\/div><div class=\"cardlink_content\"><span class=\"timestamp\">2014.06.28<\/span><div class=\"cardlink_title\"><a href=\"https:\/\/www.ka-net.org\/blog\/?p=4524\">Gmail API\u3092\u4f7f\u3063\u3066\u30e1\u30fc\u30eb\u9001\u4fe1\u3059\u308bVBA\u30de\u30af\u30ed <\/a><\/div><div class=\"cardlink_excerpt\">\u300c\u300cGmail API\u300d\u03b2\u7248\u516c\u958b\u3001\u9023\u52d5\u30a2\u30d7\u30ea\u958b\u767a\u3092\u652f\u63f4\u300d\u306b\u3082\u3042\u308b\u3088\u3046\u306b\u3001\u5148\u65e5Gmail API\u304c\u3088\u3046\u3084\u304f\u516c\u958b\u3055\u308c\u307e\u3057\u305f\u3002\r\n\r\n\u30fbGmail API - Google Developers\r\nhttps:\/\/developers.google.com\/gmai...<\/div><\/div><div class=\"cardlink_footer\"><\/div><\/div>\n<div class=\"cardlink\"><a href=\"https:\/\/www.ka-net.org\/blog\/?p=6427\"><div class=\"cardlink_thumbnail\"><img src='https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/eyecatch-Office365-120x120.png' alt='Microsoft Graph\u3092VBA\u304b\u3089\u547c\u3073\u51fa\u3057\u3066OneNote\u306e\u30da\u30fc\u30b8\u5185\u5bb9\u3092\u53d6\u5f97\u3059\u308b' width=120 height=120 \/><\/a><\/div><div class=\"cardlink_content\"><span class=\"timestamp\">2015.12.03<\/span><div class=\"cardlink_title\"><a href=\"https:\/\/www.ka-net.org\/blog\/?p=6427\">Microsoft Graph\u3092VBA\u304b\u3089\u547c\u3073\u51fa\u3057\u3066OneNote\u306e\u30da\u30fc\u30b8\u5185\u5bb9\u3092\u53d6\u5f97\u3059\u308b <\/a><\/div><div class=\"cardlink_excerpt\">\u4ee5\u524d\u66f8\u3044\u305f\u8a18\u4e8b\u300cOffice 365 unified API\u3092VBA\u304b\u3089\u547c\u3073\u51fa\u3059\u300d\u3067\u3001VBA\u304b\u3089Office 365 unified API\u3092\u547c\u3073\u51fa\u3059\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3057\u305f\u304c\u3001\u300cOffice Dev Center - Office 365 unified API ...<\/div><\/div><div class=\"cardlink_footer\"><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"\u524d\u56de\u306e\u8a18\u4e8b\u3067\u65b0\u3057\u304f\u8ffd\u52a0\u3055\u308c\u305fGoogle Docs API\u3092\u7d39\u4ecb\u3057\u307e\u3057\u305f\u3002 \u4eca\u56de\u306fDocs API\u3092VBA\u304b\u3089\u547c\u3073\u51fa\u3057\u3066\u3001\u65e2\u5b58\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306e\u60c5\u5831\u306e\u53d6\u5f97\u3084\u65b0\u898f\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306e\u4f5c\u6210\u3092\u884c\u3044\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002 \u5927\u307e\u304b\u306a\u51e6\u7406\u306e\u6d41\u308c V [&hellip;]","protected":false},"author":1,"featured_media":7113,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"[Google Docs API\u3092\u4f7f\u3063\u3066Google \u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3092\u64cd\u4f5c\u3059\u308bVBA\u30de\u30af\u30ed]","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[4,126],"tags":[],"class_list":["post-11240","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office","category-google"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/eyecatch-Google.png","jetpack_shortlink":"https:\/\/wp.me\/p4UZZr-2Vi","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/11240","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=11240"}],"version-history":[{"count":2,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/11240\/revisions"}],"predecessor-version":[{"id":11258,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/11240\/revisions\/11258"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/media\/7113"}],"wp:attachment":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=11240"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=11240"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=11240"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}