title: "Run-time error '1004' - couldn't find file"
body: <p>I am running a VBA script that mass converts dbf files to an excel spreadsheet. I have used this script a couple times earlier this week, and it worked perfectly. </p>
  
  <p>However, I tried using it again for some new data, and I am running into the error listed in the title: "Sorry we couldn't find <em>file</em>.dbf, is it possible it was moved, renamed, or deleted?"</p>
  
  <p>Frustratingly, when I go back to the older modules that worked for previous data, it no longer works! Nothing has changed in the code, so I am quite confused. Here it is" </p>
  
  <pre><code>Sub OpenDBF()
  
  Folder = "C:\Users\Smiliepants101\Documents\Brown\Thesis\CatAg\"
  
  FName = Dir(Folder &amp; "*.dbf")
  
  Do While FName &lt;&gt; ""
      Set bk = Workbooks.Open(Filename:=FName)
      bk.Close savechanges:=True
  
      FName = Dir()
  Loop
  
  End Sub
  </code></pre>