Execute a Python Script from Excel

Dev Shed Forums Sponsor:

January 25th, 2013, 03:07 AM

pw111970

Registered User

Join Date: Jan 2013

Posts: 4

Time spent in forums: 40 m 3 sec
Reputation Power: 0

Execute a Python Script from Excel

Hi,

I was not sure if this belonged in this forum - so apologies if I have posted in the wrong area.

I have a Python script which works perfectly and execeutes when I double click in Windows Explorer. I would like to execute the script when I click a button in my Excel spreadsheet.

In my Excel VBA I have used the following command:-

Call Shell(pyPath & pyFile)

pypath ="C:\Python26\python.exe "
pyFile ="script.py"

However, when the code runs I can see the Python icon flash up in my task bar but the script does not run/execute, if I exclude the 'pyFile', the Python interface opens. Can you please tell me where I am going wrong?

Thanks.

January 25th, 2013, 08:56 AM

b49P23TIvg

Contributing User

Join Date: Aug 2011

Posts: 3,458

Time spent in forums: 1 Month 2 Weeks 4 Days 6 h 26 m 43 sec
Reputation Power: 403

You might not be doing anything wrong. Have your python program exhibit a lasting external symptom.

Code:

import time
time.sleep(8) # hold the window open for a few seconds

# or

with open('a_sign.txt','w') as o:
    o.write('Hello!\n')

__________________
[code]Code tags[/code] are essential for python code!

January 28th, 2013, 03:56 AM

pw111970

Registered User

Join Date: Jan 2013

Posts: 4

Time spent in forums: 40 m 3 sec
Reputation Power: 0

Quote:

Originally Posted by b49P23TIvg

You might not be doing anything wrong. Have your python program exhibit a lasting external symptom.

Code:

import time
time.sleep(8) # hold the window open for a few seconds

# or

with open('a_sign.txt','w') as o:
    o.write('Hello!\n')

Thank you for the reply - I used the code and when I execute my VB script all I see is a 'black' python screen and the script does not execute. The strange thing is that it appears to be an intermittent issue - sometimes the script works and other times it doesn't, but I cannot find where the issue lies as I am not making any changes to the VB or Python scripts.

February 8th, 2013, 01:03 AM

pyJer

Registered User

Join Date: Feb 2013

Location: California, USA

Posts: 6

Time spent in forums: 9 h 10 m 21 sec
Reputation Power: 0

Apply this VBA code to your folders and files. It worked for
me using Excel 2003.

Code:

Private Sub CommandButton1_Click()
Dim pyPrgm As String, pyScript As String
pyPrgm = "C:\Python33\python.exe "
pyScript = "C:\Python33\MyScripts\test1.py"
Call Shell(pyPrgm & pyScript, vbMaximizedFocus)
End Sub

Execute a Python Script from Excel

Developer Shed Advertisers and Affiliates