title: How to call a Bash script from VBA (Excel)
body: <p>How can I run a <code>bash</code> file using VBA on MAC OSX </p>
  
  <p>I tried the following code</p>
  
  <pre><code>location = FolderPath(ThisWorkBook.FullName) 
  </code></pre>
  
  <p>which returns the current directory minus the file name.  </p>
  
  <p>followed by </p>
  
  <pre><code>Shell(location &amp;"runmybatch.sh")
  </code></pre>
  
  <p>I did this because the bash script is located within the same folder as the excel spreadsheet.  </p>