title: Add list item to sharepoint list using vba
body: <p>Im trying to create an excel tool that will add list item to sharepoint custom list. I had theinitial code but i am getying an error "couldnt find installable ISAM". My excel is 2016 and running in windows 10. How can i fix this issue?</p>
  
  <pre><code>Public Const sDEMAND_ROLE_GUID As String = "{6AA0B273-2548-49ED-9592-78243D4353AC}"
  Public Const sSHAREPOINT_SITE As String = "https://eu001-sp.domain.com/sites/"
  
  Sub TestPullFromSharepoint()
  
  Dim cn As ADODB.Connection
  Dim rs As ADODB.Recordset
  Dim sConn As String
  Dim sSQL As String
  Dim ID As String
  
  sConn = "Provider=Microsoft.ACE.OLEDB.12.0;DATABASE=" &amp; sSHAREPOINT_SITE &amp; ";" &amp; _
  "LIST=" &amp; sDEMAND_ROLE_GUID &amp; ";Extended Properties='Excel 8.0;HDR=YES;IMEX=1;';"
  
      Set cn = New ADODB.Connection
      Set rs = New ADODB.Recordset
      With cn
          .ConnectionString = sConn
          .Open
      End With
  sSQL = "SELECT tbl.[name] FROM [Library Name] as tbl where tbl.[id] = 14"
  rs.Open sSQL, cn, adOpenStatic, adLockOptimistic
  
  End Sub
  </code></pre>