title: Updating OneNote from VBA Excel
body: <p>I'm trying to automate the addition of a link to a report in OneNote. Basically, I have a already running macro producing a daily report in VBA Excel and saving a values only copy in a given folder. I would now like to add to the code so that an hyperlink is created in OneNote so the end-user may access the values-only file by cliking on that hyperlink.</p>
  
  <p>I've found a piece of VBA code that creates a new page in a Notebook on Microsoft webpage: <a href="http://msdn.microsoft.com/en-us/library/hh377183%28v=office.14%29" rel="nofollow">Create New Page</a></p>
  
  <p>I have modified the code so that it'll go to the Notebook, Section and then Page I tell it to. Then I can have VBA it fetch back the PageContent through XML format.</p>
  
  <p>Now here's the thing: I have a table for the month that starts only with one line two columns ie. the headers (report date and link). Now everyday, I wish to add a line to that table before writing the day's date and the link. </p>
  
  <p>How would I do that in OneNote with VBA Excel ? Is it possible ? Or would I need to change to VB or C# to be able to use Office-InterOp to do so??</p>
  
  <p>If I manage to create an extra line, I think I'd have no problem finding the two empty cells and writing the date and an hyperlink. </p>
  
  <p>Can someone please help?</p>
  
  <p>thanks
  Sebastien</p>