title: VBA to access Sharepoint with excel VBA FileSystemObject
body: <p>I am trying to access a folder in Sharepoint that is secured (https). I am using a little VBA macro in excel that uses the file system object . see code below that was found in similar thread. the macro would open the .csv file in the folder and scan for a certain string.</p>
  <p>Sometimes it would work but sometimes it would say 'path not found' in that case I would open the sharepoint site with Microsoft Explorer (browser) and then it all would have worked.
  Now that explorer has been decommissioned I cannot open that path in explorer anymore .</p>
  <p>any suggestion ? I know mapping/syncing the sharepoint would be another option but I want my tool to be used by different users and I guess mapping/syncing would make the new path , user dependent .</p>
  <pre class="lang-vb prettyprint-override"><code>Set oFSO = CreateObject(&quot;Scripting.FileSystemObject&quot;)
  Set oFolder = oFSO.GetFolder(//companyname.sharepoint.com@ssl/sites/Invoices/Shared Documents/Tre/daily)
  
  For each oFile in oFolder.Files
   ...etc etc.
  </code></pre>
  <p>thanks
  Marthomas</p>