none
Excel Macro to copy selected range to OneNote RRS feed

  • Question

  • Hello,

    I would like to have a macro that would export the selected range to OneNote. I used the code found http://msdn.microsoft.com/en-us/library/hh377183(v=office.14) and was able to tweak it a little but hit a brick wall. The tweaked code prompts the user to select a range. If one cell is selected then it copies it to OneNote as text. If more then one cell is selected nothing happens. Ideally I would like to select a range and then paste it into a notebook as a table.

    Are there any suggestions on how to accomplish this?

    Thank you,

    David

    Tuesday, February 12, 2013 9:22 PM

All replies

  • Hi David,

    Thanks for posting in the MSDN Forum.

    I will involve some experts into your thread to see whether they can help you out. There might be some time delay, appreciate for your patience.

    Have a good day,

    Tom


    Tom Xu [MSFT]
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Thursday, February 14, 2013 5:57 AM
    Moderator
  • Hello David,

    I'm sorry but we don't have any recommendations to offer regarding this.  OneNote is very limited in what can be done via VBA.

    Best Regards,
    Chad

    Wednesday, March 13, 2013 2:40 PM