title: I need to rename a file in VBA, but getting "File Not Found" when it's clearly there
body: <p>Help! I'm getting a <code>File Not Found</code> error when trying to rename a file with a variable. The variable is a <code>string</code>. </p>
  
  <p>I can look at the variable and it's the exact filename that is there, but when I run the code, it says "not found"!</p>
  
  <pre><code>Dim filePath, fileName, absPath, newPath As String
  filePath = "P:\Automated\"
  fileName = MySite.GetResult
  absPath = filePath &amp; fileName
  newPath = "P:\Automated\NEW.csv"
  
  'The following is a rename from CuteFTP Pro COM Object:
  '(Getting the same result from this and the below "Name".
  'MySite.LocalRename "P:\Automated\" &amp; fileName, "P:\Automated\NEW.csv"
  
  Name absPath As newPath
  </code></pre>