{"id":1468,"date":"2018-11-13T20:15:05","date_gmt":"2018-11-13T11:15:05","guid":{"rendered":"http:\/\/xn--4gqynm0cew8m.asia\/?p=1468"},"modified":"2022-05-12T16:55:46","modified_gmt":"2022-05-12T07:55:46","slug":"%e3%80%90vba%e3%80%91excel-vba%e3%81%a7onenote%e3%82%92%e6%93%8d%e4%bd%9c%e3%81%99%e3%82%8b","status":"publish","type":"post","link":"http:\/\/xn--4gqynm0cew8m.asia\/?p=1468","title":{"rendered":"\u3010VBA\u3011Excel VBA\u3067OneNote\u3092\u64cd\u4f5c\u3059\u308b"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">\u9054\u6210\u3057\u305f\u3044\u4e8b<\/h3>\n\n\n\n<p>\u30fbExcel VBA\u3067OneNote\u3092\u65b0\u898f\u3067\u4f5c\u6210\u3059\u308b\u3002<\/p>\n\n\n\n<p>\u30fbOneNote\u306e\u6587\u7ae0\u3082Excel\u306e\u30c7\u30fc\u30bf\u304b\u3089\u8ee2\u8f09\u3059\u308b\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u307e\u305a\u53c2\u8003\u306b\u3057\u305f\u30bd\u30fc\u30b9<\/h3>\n\n\n\n<p><a href=\"https:\/\/social.msdn.microsoft.com\/Forums\/en-US\/fcb2fbc9-bbfb-4db3-9874-82c279d17380\/create-onenote-section-and-pages-from-excel-data?forum=exceldev\">Microsoft Developer Community\u306e\u3053\u306e\u30b9\u30ec\u30c3\u30c9<\/a><\/p>\n\n\n\n<p><span class=\"kwd\">\u3000\u306e\u4e2d\u306e\u300cSub<\/span><span class=\"pln\"> SectionAndPageCreator<\/span><span class=\"pun\">()\u300d\u3092\u4f7f\u3044\u307e\u3057\u305f\u3002<\/span><\/p>\n\n\n\n<p>\u3069\u3046\u3084\u3089\u3001Excel\u306e\u30c7\u30fc\u30bf\u3092xml\u5f62\u5f0f\u306b\u3057\u3066\u3001OneNote\u306b\u9069\u7528\u3068\u3044\u3046\u9806\u5e8f\u307f\u305f\u3044<\/p>\n\n\n\n<p>\uff08\u305d\u3082\u305d\u3082OneNote\u304cxml\u5f62\u5f0f\u306e\u3088\u3046\uff09<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u3084\u3089\u306a\u3044\u3068\u3044\u3051\u306a\u304b\u3063\u305f\u3053\u3068<\/h3>\n\n\n\n<p>\u30fbActivate Libraries \uff08\u3061\u3083\u3093\u3068Page\u306e\u6700\u5f8c\u306b\u7e8f\u3081\u3066\u304f\u308c\u3066\u3044\u305f\u306e\u306b\u8aad\u3093\u3067\u306a\u304b\u3063\u305f\uff09<\/p>\n\n\n\n<p>\u4ee5\u4e0b\u306eLibraries\u3092\u30a2\u30af\u30c6\u30a3\u30d9\u30a4\u30c8\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u3002<\/p>\n\n\n\n<p><span style=\"display: inline !important; float: none; background-color: transparent; color: #333333; font-family: 'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; list-style-type: none; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;\">Visual Basic for Applications, <\/span><span style=\"display: inline !important; float: none; background-color: transparent; color: #333333; font-family: 'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; list-style-type: none; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;\">Microsoft Excel 16.0 Object Library, OLE Automation, Microsoft Office 16.0 Object Library, Microsoft OneNote 15.0 Extended Object Library, Microsoft OneNote 15.0 Object Library, Microsoft XML, v6.0.<\/span><\/p>\n\n\n\n<p>\u30fb<a href=\"https:\/\/blogs.msdn.microsoft.com\/jpsql\/2016\/11\/25\/howtouse_msxml2domdocument\/\">Windows 8 \u4ee5\u964d\u306e MSXML2.DOMDocument \u306e\u4f7f\u7528\u65b9\u6cd5<\/a><\/p>\n\n\n\n<p>\u4eca\u56de\u53c2\u7167\u3057\u305f\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u3067\u306f\u5927\u4e08\u592b\u3060\u3063\u305f\u3093\u3067\u3059\u304c\u3001\u305d\u308c\u4ee5\u5916\u306e\u3092\u53c2\u8003\u306b\u3059\u308b\u3068\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u554f\u984c\u306b\u76f4\u9762\u3059\u308b\u53ef\u80fd\u6027\u3002<\/p>\n\n\n\n<p>When\uff1a\u300cMSXML2.DOMDocument\u3092\u8a18\u8ff0\u3059\u308b\u3068\u304d\u300d<\/p>\n\n\n\n<p>Condition\uff1a\u300cOS\u304cWindows8\u4ee5\u964d\u300d<\/p>\n\n\n\n<p>\u21d2<span style=\"display: inline !important; float: none; background-color: transparent; color: #555555; cursor: text; font-family: -apple-system,'BlinkMacSystemFont','Helvetica Neue',Helvetica,'Roboto',Arial,'Hiragino Sans','Hiragino Kaku Gothic ProN',Meiryo,sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;\">MSXML2.DOMDocument<\/span>\u304c\u52d5\u304d\u307e\u305b\u3093\u6c57<\/p>\n\n\n\n<p>Solutions\uff1a<\/p>\n\n\n\n<p><span style=\"display: inline !important; float: none; background-color: transparent; color: #333333; font-family: 'Segoe UI',Tahoma,Arial,'Helvetica Neue',Helvetica,Sans-Serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;\">MSXML2.DOMDocument \u3067\u306f\u306a\u304f\u3001MSXML2.DOMDocument60 \u306e\u3088\u3046\u306b\u30d0\u30fc\u30b8\u30e7\u30f3\u3092\u660e\u793a\u7684\u306b\u6307\u5b9a\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u3002<\/span><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u307e\u3060\u89e3\u6c7a\u3057\u3066\u306a\u3044\u554f\u984c<\/h3>\n\n\n\n<p>OpenHierarchy\u3092\u5b9f\u884c\u3059\u308b\u3068\u30aa\u30fc\u30c8\u30e1\u30fc\u30b7\u30e7\u30f3\u30a8\u30e9\u30fc\u306b\u306a\u308b\u554f\u984c\u3002<\/p>\n\n\n\n<p>\u307e\u3060\u3061\u3083\u3093\u3068\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u898b\u308c\u3066\u306a\u3044\u306e\u3067\u3001OpenHierarchy\u304c\u554f\u984c\u3067\u306a\u3044\u306e\u304b\u3082\u3057\u308c\u306a\u3044\u3067\u3059\u304c\u3002<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u300c\u82f1\u8a9e\u306f\u77e5\u899a\u3067\u558b\u308c\u308b\uff01\u300d\u3068\u3044\u3046\u30ef\u30fc\u30af\u30a2\u30a6\u30c8\u3092\u3057\u3066\u3044\u307e\u3059\uff01<\/h2>\n\n\n\n<p><a href=\"https:\/\/www.meetup.com\/englishperception\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/www.meetup.com\/englishperception\/<\/a><\/p>\n\n\n\n<p>\u82f1\u8a9e\u5b66\u7fd2\u3067\u306a\u304b\u306a\u304b\u558b\u308c\u305f\u308a\u3001\u805e\u3053\u3048\u308b\u3088\u3046\u306b\u306a\u3089\u306a\u3044\u65b9\u304c\u3044\u3089\u3063\u3057\u3083\u3044\u307e\u3057\u305f\u3089\u3001<br>\u305c\u3072\u53c2\u52a0\u3057\u3066\u9802\u3051\u308c\u3070\u3068\u601d\u3044\u307e\u3059\u3002<br>ZOOM\u306730\u5206\u3067\u3059\u3002\u3082\u3061\u308d\u3093\u7121\u6599\u3067\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u9054\u6210\u3057\u305f\u3044\u4e8b \u30fbExcel VBA\u3067OneNote\u3092\u65b0\u898f\u3067\u4f5c\u6210\u3059\u308b\u3002 \u30fbOneNote\u306e\u6587\u7ae0\u3082Excel\u306e\u30c7\u30fc\u30bf\u304b\u3089\u8ee2\u8f09\u3059\u308b\u3002 \u307e\u305a\u53c2\u8003\u306b\u3057\u305f\u30bd\u30fc\u30b9 Microsoft Developer Community\u306e\u3053\u306e\u30b9\u30ec\u30c3\u30c9 \u3000\u306e\u4e2d\u306e\u300cSub[&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"spay_email":"","footnotes":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false},"categories":[37],"tags":[],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/p53nwf-nG","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/xn--4gqynm0cew8m.asia\/index.php?rest_route=\/wp\/v2\/posts\/1468"}],"collection":[{"href":"http:\/\/xn--4gqynm0cew8m.asia\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/xn--4gqynm0cew8m.asia\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/xn--4gqynm0cew8m.asia\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/xn--4gqynm0cew8m.asia\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1468"}],"version-history":[{"count":3,"href":"http:\/\/xn--4gqynm0cew8m.asia\/index.php?rest_route=\/wp\/v2\/posts\/1468\/revisions"}],"predecessor-version":[{"id":19050,"href":"http:\/\/xn--4gqynm0cew8m.asia\/index.php?rest_route=\/wp\/v2\/posts\/1468\/revisions\/19050"}],"wp:attachment":[{"href":"http:\/\/xn--4gqynm0cew8m.asia\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1468"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/xn--4gqynm0cew8m.asia\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1468"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/xn--4gqynm0cew8m.asia\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1468"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}