+ Reply to Thread
Results 1 to 3 of 3

Macro to print sheet to OneNote.

  1. #1
    Registered User
    Join Date
    06-07-2013
    Location
    WV USA
    MS-Off Ver
    Excel 2010
    Posts
    16

    Macro to print sheet to OneNote.

    Hello,
    I have a current need to manipulate data in a workbook, and run a macro that will do some formatting, and close the workbook.

    I want to add some code after the formatting, but before closing the workbook that will print the sheet to a OneNote notebook. I don't mind interacting with OneNote to tell it which notebook and section that I want it to be printed to. but now i have to run the macro, then reopen the workbook and print the sheet, then close again.

    Thanks
    Last edited by excelstudent74; 07-03-2019 at 02:22 PM. Reason: solved

  2. #2
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: Macro to print sheet to OneNote.

    Found this a while back...
    Please Login or Register  to view this content.
    but I had to figure out what to put in the quotation marks first. To find the correct wording of the 'printer', set your active printer to OneNote and then run this...
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    06-07-2013
    Location
    WV USA
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: Macro to print sheet to OneNote.

    Thank you Danglor. This worked very nicely

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 11-15-2019, 02:57 AM
  2. Connect Excel and OneNote (extract data from onenote to excel)
    By MadSilence in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-27-2018, 09:22 AM
  3. Print Macro for multiple but different print pages of the same sheet
    By dgarrod in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-18-2017, 02:55 PM
  4. How Can I: Link from OneNote to a Specific Sheet/Cell in Excel?
    By Sandcastle in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-29-2015, 05:14 PM
  5. Macro slows down when I print/print preview/page break a sheet
    By Grug in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-07-2015, 08:59 PM
  6. Macro to print a sheet
    By css0911 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-27-2013, 12:56 AM
  7. Macro to Print Update and Print Sheet
    By erock24 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-26-2007, 11:10 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1