Is there an Excel VBA macro code to export data to OneNote?

Question

Is there a simple VBA macro code that will allow me to copy a few Excel cells to OneNote section?

Answer 1

Copying from Excel to OneNote is possible but you will lose important data through simple copying and pasting and a macro won't help. If you have both applications installed, just open your Excel file and select Print. From that list, choose Send to OneNote and the data from Excel will be sent to OneNote with all the items.