title: Robocopy in VBA while using strings
body: <p>I have a spreadsheet that we run to copy over a list of files/folders based on what we select. In each of these row's we have a few other formula's that with gather other information. What we are trying to do is use robocopy based on a cell's data using strings. Below is currently how we have it setup in VBA, but it does not seem to work.</p>
  
  <pre><code>sSource = Sheets("Sheet1").Range("A2").Value
  sFile = Sheets("Sheet1").Range("F2").Value
  sPath = Sheets("Sheet2").Range("C2").Value
  
  Shell "cmd /c robocopy sSource sPath sFile"
  </code></pre>
  
  <p>sSource is a network drive with the full folder path (i.e. \server1\stuff\stuff2\files)
  sPath is a local folder on the computer
  sFile is just as it sounds, the file name</p>
  
  <p>It appears that it runs successfully, but when I go to the sPath location, there are no files there, just an empty folder.</p>