VBA - Calling a .bat file or Python Script

Hi,

I'm banging my head against the wall here! I'm trying to use Excel to generate and instruction file for Python to run some complex calculations. Problem is, I can't get my Python script to run through VBA.

I've used variations of the 'Shell' command:
ie: Call Shell ("xxx", 1), Call Shell ("xxx"), Call Shell "xxx", Shell ("xxx", 1), Shell ("xxx"), Shell "xxx", etc.

As well, I have tried different string commands inside the Shell function:
Shell ("cmd") gives me the DOS Shell (in the C:\WINDOWS directory)
Shell ("cmd /c python") gives me the Python Shell
Shell ("cmd /c python myfile.py") doesn't do anything

With regards to the .bat file, I have also tried calling that to invoke Python by methods such as this:
Shell ("e:\myfile.bat")
Shell ("myfile.bat")

Anyway, nothing seems to be working for me. Please help! Thanks in advance...