Search the Community
Showing results for tags 'excell'.
Found 2 results
I had the need to create 4000 notes based on excel data because tagging system in Evernote makes search way more easier than excel. Also with Evernote I could create many Table of contents based on my needs. My excel data was well formatted - each row was going to one unique note. After searching through this forum I realized that may it is impossible to do and I decided to copy painfully one note at a time. Then IDEA!!!! came What if I create a note in Evernote, export evernote file (.enex) Open in notepad and view xml code Find out of table structure and modify to my needs Use vba Macro to convert each row as one noteI found a gentleman (Anton Fishman) on internet who worked on similar problem before and he helped me achieve my goal. I can not attach excel here - but here is the link People with good XML knowledge can help clean up the VBA code a bit to get better table format, that would be great. Remember to change the path to your liking strFile = "C:\Users\1.enex" I created my 4000 notes with required tags with click of a button, it took more time to Sync across devices than to create it. It will create one big .enex file but when you import in windows or Mac machines with File-> import, it will create all notes for you. I would appreciate people's feedback