VBA or BAT won't run python script

[32CARDS]

I have some python scripts to run using VBA,
At first it worked, then stopped working after a PC change over.
( the old pc rip'd)
I thought it may be something in the VBA module Tools/References but not really sure what to look for.
Then I tried a test .bat file and still nothing happens.
Yet when I double click on the python script file on it's own it works OK,it does what it is suppose to do.
python version is 3.4 32 bit

Anything I may have overlooked to have py scripts working through VBA again ?
Syntax currently in VBA is:

Shell "C:\\Python34\\python.exe c:\\C:\FolderTesting\\testscript.py"

Thanks

 

[32CARDS]

Re: VBA or BAT won't run python script--SOLVED

Option Explicit

Sub test()


  Dim PathCrnt As String

    ChDir "C:\directory_bat_is_in "

  PathCrnt = ActiveWorkbook.Path

  Call Shell(PathCrnt & "\name_of_batfile.BAT " & PathCrnt)

End Sub

 

[Rick Rothstein]

Syntax currently in VBA is:

Shell "C:\\Python34\\python.exe c:\\C:\FolderTesting\\testscript.py"

Why are you using double backslashes? VB, as well as Windows, uses single backslashes between path elements. See if changing all the \\ to \ works for you.

 

[32CARDS]

Why are you using double backslashes? VB, as well as Windows, uses single backslashes between path elements. See if changing all the \\ to \ works for you.

Thank for the reply MrExcel,
Yes I tried various combinations. The double backslash was suggested by the author of the py scripts, but had not tested it themselves, it was up to me.
I thought at first everything was OK, when I simply clicked on the py scripts at first, and said back, "yep, all good", an error on my part.
When I constructed the project, tried to fire the scripts in the Run of things,
nada.
Then simply searched and searched, it made sense to use bat with a dynamic folder reference. It worked. I "see" it now, this part here forces the machine to make a "direction change" ? I think;

ChDir "C:\