title: Browsing https SharePoint files and folders through local VBA
body: <p>I've searched around for some answers to this, but nothing I found seemed to work.  I'm good with VBA, but Sharepoint is not my cup of tea.  We have a corporate Sharepoint site on the web (https) where different regions submit metrics using Excel.  Each Excel file is placed in the region's respective folder.  </p>
  
  <p>What I want to be able to do is use a local workbook to navigate to the Sharepoint site, go through the folders, open each Excel workbook, and aggregate the numbers together.  The closest I've come so far is <a href="http://www.mrexcel.com/forum/excel-questions/534621-how-traverse-folders-files-sharepoint-excel-visual-basic-applications.html" rel="nofollow">this</a>. </p>
  
  <p>However, let's say my site is:</p>
  
  <pre><code>[https://teams.mycompany.com/SubTeamFolder/Forms/AllItems.aspx.]
  </code></pre>
  
  <p>Nothing gets returned when I set the site variable to this in the code from the link above.  If I set the site variable to something like:</p>
  
  <pre><code>[https://teams.mycompany.com/SubTeamFolder/AllItems/]
  </code></pre>
  
  <p>it throws error </p>
  
  <pre><code>-2147217895
  </code></pre>
  
  <p>.</p>
  
  <p>I'm open to other approaches here.  Like I said, this one seemed the most promising till I hit this wall.</p>