title: Download whole directory(folder) from sharepoint using vba-excel
body: <p>I want to download all the files that are under:</p>
  
  <p><a href="http://sharepoint.company.com/sites/Some" rel="nofollow">http://sharepoint.company.com/sites/Some</a> Site/Some Directory</p>
  
  <p>to a local directory with vba and excel. I found another question and their answers were saying that I need to map this directory to a drive but I am not able to do so. I know how to download a file from that directory if I know the name of the file but I can't download the whole directory.</p>
  
  <p>Is there a way of doing that?</p>
  
  <p>Thanks!</p>