title: Merging two text files using Shell script in VBA
body: <p>I have three String varibales in my VBA code as below:</p>
  
  <pre><code>Dim FilePath As String
  Dim FooterFilePath As String
  Dim PlusChar As String
  
  FilePath = Application.ActiveWorkbook.Path &amp; "\Bin\file.txt"
  FooterFilePath = Application.ActiveWorkbook.Path &amp; "\Bin\footer.txt"
  PlusChar = Chr(43)  'i.e. "+" sign
  </code></pre>
  
  <p>Now I am trying to merge <code>FilePath</code> and <code>FooterFilePath</code> and write the combined result in <code>FilePath</code> again i.e. overwriting it. For that I am using followng line which doesn't work:</p>
  
  <pre><code>Shell "cmd.exe copy /c &amp; FilePath &amp; PlusChar &amp; FooterFilePath &amp; FilePath", 0
  </code></pre>
  
  <p>I know I have syntaxing issue here but I just don't know how to pass three variables into Shell command.</p>