{"id":8588,"date":"2017-06-16T10:45:21","date_gmt":"2017-06-16T01:45:21","guid":{"rendered":"https:\/\/www.ka-net.org\/blog\/?p=8588"},"modified":"2017-06-16T11:38:56","modified_gmt":"2017-06-16T02:38:56","slug":"evernote-cloud-sdk%e3%82%92%e4%bd%bf%e3%81%a3%e3%81%a6%e7%89%b9%e5%ae%9a%e3%81%ae%e6%96%87%e5%ad%97%e5%88%97%e3%81%8c%e5%90%ab%e3%81%be%e3%82%8c%e3%82%8b%e3%83%8e%e3%83%bc%e3%83%88%e3%82%92%e6%a4%9c","status":"publish","type":"post","link":"https:\/\/www.ka-net.org\/blog\/?p=8588","title":{"rendered":"Evernote Cloud SDK\u3092\u4f7f\u3063\u3066\u7279\u5b9a\u306e\u6587\u5b57\u5217\u304c\u542b\u307e\u308c\u308b\u30ce\u30fc\u30c8\u3092\u691c\u7d22\u3059\u308bVBA\u30de\u30af\u30ed"},"content":{"rendered":"<p><a href=\"https:\/\/www.ka-net.org\/blog\/?p=8574\" title=\"Evernote Cloud SDK\u3092\u4f7f\u3063\u305fVBA\u30de\u30af\u30ed | \u521d\u5fc3\u8005\u5099\u5fd8\u9332\" target=\"_blank\">\u524d\u56de\u306e\u8a18\u4e8b<\/a>\u3067\u3001VBA\u304b\u3089Evernote Cloud SDK\u3092\u4f7f\u3063\u3066\u30ce\u30fc\u30c8\u30d6\u30c3\u30af\u540d\u3092\u5217\u6319\u3059\u308b\u30de\u30af\u30ed\u3092\u7d39\u4ecb\u3057\u307e\u3057\u305f\u304c\u3001\u4eca\u56de\u306f\u6307\u5b9a\u3057\u305f\u6587\u5b57\u5217\u304c\u542b\u307e\u308c\u308b\u30ce\u30fc\u30c8\u3092\u691c\u7d22\u3059\u308b\u30de\u30af\u30ed\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n<p>SDK\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3084Developer Token\u306e\u53d6\u5f97\u65b9\u6cd5\u306f\u4e0b\u8a18\u8a18\u4e8b\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044\u3002<\/p>\n<div class=\"cardlink\"><a href=\"https:\/\/www.ka-net.org\/blog\/?p=8574\"><div class=\"cardlink_thumbnail\"><img src='https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/eyecatch-OfficeVBA-120x120.png' alt='Evernote Cloud SDK\u3092\u4f7f\u3063\u305fVBA\u30de\u30af\u30ed' width=120 height=120 \/><\/a><\/div><div class=\"cardlink_content\"><span class=\"timestamp\">2017.06.15<\/span><div class=\"cardlink_title\"><a href=\"https:\/\/www.ka-net.org\/blog\/?p=8574\">Evernote Cloud SDK\u3092\u4f7f\u3063\u305fVBA\u30de\u30af\u30ed <\/a><\/div><div class=\"cardlink_excerpt\">3\u5e74\u307b\u3069\u524d\u306bEvernote for Windows\u3092\u64cd\u4f5c\u3059\u308bVBA\u30de\u30af\u30ed\u306b\u3064\u3044\u3066\u8a18\u4e8b\u3092\u66f8\u304d\u307e\u3057\u305f\u3002\r\n\r\n\r\n\r\n\u5148\u65e5Evernote\u306e\u958b\u767a\u8005\u30b5\u30a4\u30c8\u3092\u773a\u3081\u3066\u3044\u305f\u3068\u3053\u308d\u3001COM\u3082\u30b5\u30dd\u30fc\u30c8\u3057\u3066\u3044\u308b\u300cEvernote Cloud SDK 2.0 for Windo...<\/div><\/div><div class=\"cardlink_footer\"><\/div><\/div>\n<p><span style=\"color: #ff0000; font-weight: bold;\">\u203b \u4e0b\u8a18\u30b3\u30fc\u30c9\u4e2d\u306e\u300cDeveloper Token\u300d\u3068\u300cNoteStore URL\u300d\u306f\u305d\u308c\u305e\u308c\u81ea\u5206\u3067\u53d6\u5f97\u3057\u305f\u3082\u306e\u306b\u7f6e\u304d\u63db\u3048\u3066\u304f\u3060\u3055\u3044\u3002<\/span><\/p>\n<pre class=\"brush: vb; title: ; notranslate\" title=\"\">Option Explicit\r\n\r\nPublic Sub Sample()\r\n  Dim en As Object 'EvernoteSDK.ENSessionForCOM\r\n  Dim enSearch As Object 'EvernoteSDK.ENNoteSearchForCOM\r\n  Dim enNotesList As Object 'EvernoteSDK.ENCollection\r\n  Dim enRef As Object 'EvernoteSDK.ENNoteRef\r\n  Dim enNote As Object 'EvernoteSDK.EdamNote\r\n  Dim txtFind As String\r\n  Dim txtContent As String\r\n  Dim i As Long\r\n  \r\n  Const SearchScope_All = 7 'EvernoteSDK.SearchScope.SearchScope_All\r\n  Const SortOrder_RecentlyUpdated = 4 'EvernoteSDK.SortOrder.SortOrder_RecentlyUpdated\r\n  \r\n  Const DeveloperToken As String = &quot;(Developer Token)&quot;\r\n  Const NoteStoreUrl As String = &quot;(NoteStore URL)&quot;\r\n  Const MaxResults As Long = 100 '\u7d50\u679c\u306e\u6700\u5927\u4ef6\u6570\r\n  \r\n  txtFind = &quot;\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3&quot; '\u691c\u7d22\u3059\u308b\u6587\u5b57\u5217\r\n  \r\n  Set en = CreateObject(&quot;EvernoteSDK.ENSessionForCOM&quot;)\r\n  With en\r\n    .SetSharedSessionDeveloperToken DeveloperToken, NoteStoreUrl\r\n    If .sharedSession.IsAuthenticated = False Then Exit Sub\r\n    \r\n    Set enSearch = CreateObject(&quot;EvernoteSDK.ENNoteSearchForCOM&quot;)\r\n    Set enNotesList = .sharedSession.FindNotesForCOM( _\r\n                        enSearch.NoteSearch(txtFind), _\r\n                        Nothing, _\r\n                        SearchScope_All, _\r\n                        SortOrder_RecentlyUpdated, _\r\n                        MaxResults)\r\n    If enNotesList.Count &gt; 0 Then\r\n      With ActiveSheet\r\n        .Cells(1, 1).Value = &quot;Note Title&quot;\r\n        .Cells(1, 2).Value = &quot;Notebook&quot;\r\n        .Cells(1, 3).Value = &quot;Date Created&quot;\r\n        .Cells(1, 4).Value = &quot;Date Updated&quot;\r\n        .Cells(1, 5).Value = &quot;TextContent&quot;\r\n        .Rows(1).Font.Bold = True\r\n        For i = 1 To enNotesList.Count\r\n          Set enRef = enNotesList(i).NoteRef\r\n          Set enNote = en.sharedSession.DownloadNote(enRef)\r\n          txtContent = enNote.TextContent\r\n          If Len(txtContent) &gt;= 100 Then txtContent = Left(txtContent, 100) '\u9577\u3044\u672c\u6587\u306f\u4e00\u90e8\u306e\u307f\u8868\u793a\r\n          .Cells(i + 1, 1).Value = enNotesList(i).Title\r\n          .Cells(i + 1, 2).Value = enNotesList(i).Notebook.Name\r\n          .Cells(i + 1, 3).Value = enNotesList(i).Created\r\n          .Cells(i + 1, 4).Value = enNotesList(i).Updated\r\n          .Cells(i + 1, 5).Value = txtContent\r\n        Next\r\n      End With\r\n    End If\r\n  End With\r\n  \r\n  MsgBox &quot;\u51e6\u7406\u304c\u7d42\u4e86\u3057\u307e\u3057\u305f\u3002&quot;, vbInformation + vbSystemModal\r\nEnd Sub<\/pre>\n<p>\u4e0a\u8a18\u30de\u30af\u30ed\u3092\u5b9f\u884c\u3059\u308b\u3068\u3001\u9078\u629e\u4e2d\u306e\u30b7\u30fc\u30c8\u306b\u30ce\u30fc\u30c8\u540d\u3084\u30ce\u30fc\u30c8\u30d6\u30c3\u30af\u306e\u30bf\u30a4\u30c8\u30eb\u3001\u672c\u6587\u306e\u4e00\u90e8\u7b49\u304c\u51fa\u529b\u3055\u308c\u307e\u3059(\u9014\u4e2dSDK\u306e\u4ed5\u69d8\u306b\u3088\u308a\u3001\u78ba\u8a8d\u7528\u306e\u30e1\u30c3\u30bb\u30fc\u30b8\u30dc\u30c3\u30af\u30b9\u304c\u8868\u793a\u3055\u308c\u307e\u3059)\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Evernote_SDK_VBA_02_01.jpg\" alt=\"\" width=\"815\" height=\"614\" class=\"alignnone size-full wp-image-8589\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Evernote_SDK_VBA_02_01.jpg 815w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Evernote_SDK_VBA_02_01-300x226.jpg 300w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Evernote_SDK_VBA_02_01-768x579.jpg 768w\" sizes=\"auto, (max-width: 815px) 100vw, 815px\" \/><\/p>\n<p>\u4e0a\u8a18\u30de\u30af\u30ed\u306f<a href=\"https:\/\/github.com\/evernote\/evernote-cloud-sdk-windows\/tree\/master\/samples\/VBA\" title=\"Evernote Cloud SDK 2.0 for Windows\" target=\"_blank\">GitHub\u306b\u3042\u3063\u305f\u30b5\u30f3\u30d7\u30eb\u30b3\u30fc\u30c9<\/a>\u3092\u5143\u306b\u3057\u3066\u3044\u307e\u3059\u304c\u3001<span style=\"color: #ff0000; font-weight: bold;\">\u30b5\u30f3\u30d7\u30eb\u306f\u52d5\u304b\u306a\u3044\u306e\u3067\u5f53\u3066\u306b\u306a\u3089\u306a\u3044<\/span>\u3067\u3059\u3002<\/p>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/?p=8574\" title=\"Evernote Cloud SDK\u3092\u4f7f\u3063\u305fVBA\u30de\u30af\u30ed | \u521d\u5fc3\u8005\u5099\u5fd8\u9332\" target=\"_blank\">\u524d\u56de\u306e\u8a18\u4e8b<\/a>\u3067\u3082\u66f8\u3044\u305f\u901a\u308a\u3001\u30aa\u30d6\u30b8\u30a7\u30af\u30c8 \u30d6\u30e9\u30a6\u30b6\u3067\u30e1\u30f3\u30d0\u30fc\u8868\u793a\u3082\u3055\u308c\u306a\u3044\u306e\u3067\u3001<span style=\"color: #ff0000; font-weight: bold;\">\u30ac\u30c1\u3067\u624b\u63a2\u308a\u72b6\u614b<\/span>\u3001\u6b63\u76f4\u4e0a\u8a18\u51e6\u7406\u306b\u81f3\u308b\u307e\u3067\u8a66\u884c\u932f\u8aa4\u306e\u9023\u7d9a\u3067\u3057\u305f\u3002<\/p>\n<p>\u691c\u7d22\u3057\u3066\u3082\u5927\u3057\u305f\u60c5\u5831\u3082\u30d2\u30c3\u30c8\u3057\u306a\u3044\u305f\u3081\u3001\u4e00\u756a\u53c2\u8003\u306b\u306a\u308b\u306e\u306f<a href=\"https:\/\/github.com\/evernote\/evernote-cloud-sdk-windows\/tree\/master\/src\/EvernoteSDK\" title=\"Evernote Cloud SDK 2.0 for Windows\" target=\"_blank\">SDK\u306e\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9<\/a>\u3068\u3044\u3046\u3001<span style=\"color: #ff0000; font-weight: bold;\">\u306a\u304b\u306a\u304b\u306e\u82e6\u884c\u3063\u3077\u308a<\/span>\u3092\u767a\u63ee\u3059\u308bEvernote Cloud SDK(COM)\u306e\u51e6\u7406\u3067\u3059\u304c\u3001\u3069\u306a\u305f\u304b\u306e\u53c2\u8003\u3067\u306a\u308c\u3070\u5e78\u3044\u3067\u3059\u3002<br \/>\n(\u30b3\u30ec\u3001\u3072\u3087\u3063\u3068\u3057\u305f\u3089\u81ea\u5206\u3067API\u547c\u3093\u3060\u65b9\u304c\u624b\u3063\u53d6\u308a\u65e9\u3044\u306e\u3067\u306f\uff1f\u3068\u3001\u601d\u308f\u306a\u304f\u3082\u306a\u3044\u3067\u3059)<\/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","protected":false},"excerpt":{"rendered":"\u524d\u56de\u306e\u8a18\u4e8b\u3067\u3001VBA\u304b\u3089Evernote Cloud SDK\u3092\u4f7f\u3063\u3066\u30ce\u30fc\u30c8\u30d6\u30c3\u30af\u540d\u3092\u5217\u6319\u3059\u308b\u30de\u30af\u30ed\u3092\u7d39\u4ecb\u3057\u307e\u3057\u305f\u304c\u3001\u4eca\u56de\u306f\u6307\u5b9a\u3057\u305f\u6587\u5b57\u5217\u304c\u542b\u307e\u308c\u308b\u30ce\u30fc\u30c8\u3092\u691c\u7d22\u3059\u308b\u30de\u30af\u30ed\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002 SDK\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3084Develop [&hellip;]","protected":false},"author":1,"featured_media":7112,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"[Evernote Cloud SDK\u3092\u4f7f\u3063\u3066\u7279\u5b9a\u306e\u6587\u5b57\u5217\u304c\u542b\u307e\u308c\u308b\u30ce\u30fc\u30c8\u3092\u691c\u7d22\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,48,152],"tags":[],"class_list":["post-8588","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office","category-excel-office","category-evernote"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/eyecatch-ExcelVBA.png","jetpack_shortlink":"https:\/\/wp.me\/p4UZZr-2ew","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/8588","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=8588"}],"version-history":[{"count":3,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/8588\/revisions"}],"predecessor-version":[{"id":8592,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/8588\/revisions\/8592"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/media\/7112"}],"wp:attachment":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8588"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8588"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8588"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}