A family of Microsoft products that enable users to capture, organize, and reuse notes electronically.
In Excel or Word you are able to use OLE Automation with the Object Library for
OneNote 2010.
In the following Link you find an Article as a starting Point!
https://code.msdn.microsoft.com/office/onenote-2010-retrieve-data-023e69c0
Hier are some Information what you will expect.
Building the Sample
Use any VBA host including Excel 2010, PowerPoint 2010, or Word 2010. OneNote 2010 is not a VBA host.
In your VBA host, add references to the following external libraries using the Add References dialog:
- Microsoft OneNote 14.0 Object Library
- Microsoft XML, v6.0
OneNote's GetHierarchy method allows you to get meta-data and data about the OneNote Notebooks.
Paste all this code into a module, place the cursor within the ListOneNoteNotebooks procedure, and press F5.
But the Problem is how to find the OneNote14 Type Library?
Even on PC's with the Office 2010 installed I did not find it!?
Sub ListOneNoteNotebooks()
' Connect to OneNote 2010.
' OneNote will be started if it's not running.
Dim oneNote As OneNote14.Application
Set oneNote = New OneNote14.Application
...