Running a Python Script from Excel VBA

Hi All,

I want to be able to invoke a Python script using VBA. With the following code I'm getting the following error:

Method 'Run' of object 'IWshShell3' failed

Please Login or Register  to view this content.

Any help would be appreciated.

Cheers

Dean

You could use Shell().

Maybe:

Please Login or Register  to view this content.

Thanks Kenneth,

That has got rid of the error.

Now I can see a CMD prompt flash open and close but doesn't seem to be running the Python script

Help is appreciated

Cheers

Dean

You can use /C to close the shell or /K to keep it open so you can see what happened.

e.g.

Please Login or Register  to view this content.

When working, you can use vbHide. If you need it to wait to finish, there are shellwait routines.

I am having the same problem. Is anyone able to help? Same syntax as Dean McK