title: ADODB string connection fo SharePoint list via VBA
body: <p>With connection string like this:</p>
  
  <pre><code>"Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=0;RetrieveIds=Yes;" &amp; _
  "DATABASE=" &amp; sSHAREPOINT_SITE &amp; ";" &amp; _
  "LIST=" &amp; sDEMAND_ROLE_GUID &amp; ";"
  </code></pre>
  
  <p>on Windows 7 computer with Excel 2007 ADODB connection is opened without any problem but when I try this code on Windows 10 computer I receive error (Invalid argument). </p>
  
  <p>When I changed connection strong to this:</p>
  
  <pre><code>"Provider=Microsoft.ACE.OLEDB.16.0;WSS;IMEX=0;RetrieveIds=Yes;" &amp; _
  "DATABASE=" &amp; sSHAREPOINT_SITE &amp; ";" &amp; _
  "LIST=" &amp; sDEMAND_ROLE_GUID &amp; ";"
  </code></pre>
  
  <p>I also receive error (Invalid argument). My question is there any difference when I use different operation systems and I try to connect to SharePoint by the same code? </p>
  
  <p>What connection string should I use to open connection with SharePoint on Windows 10 using Excel 2016?</p>
  
  <p>Thanks for any advices.</p>