title: VBA Check If Sharepoint Folder Exists
body: <p>I am trying to determine if a Sharepoint folder exists in Excel VBA using the URL path and if not create the folder.  I can do this easily if I map the network drive:</p>
  
  <pre><code> myWorkbookBasePath = "Z:Documents\Reports\2013\"
  
   If Dir(myWorkbookBasePath, vbDirectory) = "" Then
          MkDir myWorkbookBasePath
   End If
  </code></pre>
  
  <p>However, I can not figure out how to do it using the URL path.  If I use </p>
  
  <pre><code>myWorkBookBasePath= "http://sharepoint/Documents/Reports/2013/"
  </code></pre>
  
  <p>I get error code 52.  Can anyone tell me how to make it work with the URL path?  </p>