title: MS Access VBA FileSystemObject does not accept path with spaces in them
body: <p>How do I get around the limitation VBA have of not allowing spaces in file path when using the FileSystemObject?</p>
  
  <p>Here is my code:</p>
  
  <pre><code>from= "C:\Users\MyAccount\Desktop\a.txt"
  to= "C:\Users\MyAccount\Desktop\Folder Name With Spaces\b.txt"
  Dim fso As New FileSystemObject
  Set fso = CreateObject("Scripting.FileSystemObject")
  fso.CopyFile from, to
  </code></pre>
  
  <p>I have already tried the trick with adding " before any spaces, it doesn't work.  The "Bad FileName or Number" error actually pops up.</p>
  
  <p>I have also tried to replace any spaces with %20, which also does not work.</p>
  
  <p>To clarify, I don't know the path beforehand, it is entered by the user.</p>