md2z34
md2z34
/ Evernote_Import_Export_Macro.vba
Last active
March 1, 2022 18:11
This Excel VBA macro can import and export Evernote files (*.enex). OutputNotesXML() macro (taken from https://gist.github.com/robertpateii/2992931) is able to save an Excel workbook into the file evernote-import.enex, that can be imported to Evernote later on. ReadNotesXML() macro (my contribution) is able to read *.enex files exported from Eve…
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Option Explicit | |
| Sub OutputNotesXML() | |
| Dim iRow As Long | |
| Close #1 | |
| With ActiveSheet | |
| 'For iRow = 2 To 2 | |
| Open ThisWorkbook.Path & "\evernote-import.enex" For Output As #1 |