First time here? Check out the FAQ!

OneNote Macros to create an Excel spreadsheet

0 votes
asked by (120 points) about OneNote
edited by

I am new to OneNote and I would like to create a To Do List in OneNote. Then create a macro that will generate the number of outstanding To Dos on each sheet in a group to an Excel spreadsheet. In the Excel spreadsheet I need the outstanding To Dos (what sheet it came from). This output will populate the Excel spreadsheet for pie charts. Is this even possible?

1 Answer

0 votes
answered by (236k points)
edited by

I don't think there is a way to do this because OneNote won't allow you to create Excel spreadsheets. The only thing you can do is to make an Excel file embedded inside OneNote. For this process I recommend accessing the websites listed through the Google Search.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register