title: Changing working directory from Excel vba shell
body: <p>For work, I'm trying to run a Python script from an Excel VBA macro.</p>
  
  <p>The macro is as follows - </p>
  
  <pre><code>Sub Plot()
  
  Shell "C:\Users\maheshda\AppData\Local\Continuum\Anaconda3\python.exe C:\Users\maheshda\Tool\Tool\Main.py", vbNormalFocus
  
  End Sub
  </code></pre>
  
  <p>The script runs just fine when run from the command line, but unfortunately, because I'm using relative filepaths in the Python script (at one point, I call files from '../Input/') the script crashes because the current working directory isn't C:\Users\maheshda\Tool\Tool. </p>
  
  <p>How can I change the working directory from within the macro? Thank you!</p>