VBA code to create a new page in a specific section of OneNote and paste content from Excel.

  • Hello,

    I am looking for a way to automate the process of creating a new page in a specific section of OneNote and pasting content from Excel into it. After some research, I found a VBA code that seems to do the job. Here's the code:

    However, I am running into an issue where the code directs me to OneNote, but not to the specific section that I want to create the new page in. Instead, it sometimes takes me to a random section or the one that is already opened in the notebook. Could you please advise me on how to modify the code to ensure that it directs me to the correct section in my OneNote notebook?

    Thank you!

    Best regards,


  • Hi and Welcome to the Forum :)

    Personally, never worked with OneNote ...

    So did some research and located a couple of "potentially" interesting sites :

    How to Embed Excel Data into Microsoft OneNote
    Thanks to Office integration, it's entirely possible to use Excel data in your OneNote notes. Here's how.

    Hope this will help

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!