title: Run and execute a python script from VBA
body: <p>I'm trying to run a python script from my VBA module. I've tried pretty much every example I've seen on the internet and so for have had no luck. 
  In the VBA module I also run a .bat file, and it works perfectly:</p>
  
  <pre><code>batchname = "U:\Backup Bat File.bat"
  
  Shell batchname, vbNormalFocus
  </code></pre>
  
  <p>Next I need to run the python script, which is located in the same folder as the excel file.
  Right now I'm trying out this:</p>
  
  <pre><code>Dim Ret_Val
  
  Dim args
  
  args=Activeworkbook.Path &amp; "\beps_output.py"
  
  Ret_Val = Shell("C:\python34\python.exe" &amp; args, vbNormalFocus)
  </code></pre>
  
  <p>It doesn't error out, but nothing happens. I'm a little confused at what the "Ret_Val" (return value?) does here, and why it isn't running.</p>