title: How to add items to a Sharepoint list using Excel VBA?
body: <p>I have an Excel-based application that gathers some user input, and makes some calculations based on that user input.  The application itself doesn't store any of the user input or calculations; currently whenever a user runs the application, it sends the data to an Access database and inserts a row into an Access table <code>xlTable</code> that's linked to a Sharepoint list.  The relevant code is:</p>
  
  <pre><code>sub sendToSharepoint(userName as string, folderPath as string, calculatedValue as long)
  
  dim db as DAO.database
  dim insertStr as string
  
  'open connection to Access db
  set db=OpenDatabase(myDatabasePath)
  
  'build insert string
  insertStr="insert into xlTable (userName,folderPath,calculatedValue,workDate) values (""" &amp; userName &amp; """,""" &amp; folderPath &amp; """," &amp; calculatedValue &amp; ","#" &amp; Now &amp; "#)"
  
  'insert values into xlTable, which adds them to the Sharepoint list
  db.execute insertStr,dbFailonError
  
  end sub
  </code></pre>
  
  <p>Because we've had some issues with Access disconnecting from Sharepoint and therefore not populating the list, and in general want to simplify our data transfer process, I'd like to send the data directly from Excel to Sharepoint without using Access.  I've read some stuff on SO about using Web Services to update Sharepoint, but I haven't been able to figure out how these work exactly, or how to implement them in VBA.</p>
  
  <p>What info would I need about my Sharepoint list to manipulate it from Excel VBA similar to the above code?  Do I need to add any references?</p>