title: How Can I run a .bat file from Excel?
body: <p>I have 5 batch files at different locations and I want to run them through Excel like below:</p>
  
  <pre><code>F:\Financial\Data\Reports\ExpensesYTD 
  Batch1.bat, Batch2.bat, Batch4.bat
  
  F:\Financial\Data\Reports\AccountPnlMTD
  Batch5.bat, Batch6.bat, Batch7.bat
  </code></pre>
  
  <p>I want to run batch files using excel by a macro..excel macro shuld call the .bat batch files where they are sited and shuld run. Please help me to do this.</p>