call a python script from excel vba

Hi all,

I am writing a python script to parse certain text in cells in a spreadsheet.

I want to pass data in columns a,b,c one row at a time to my script, let the script parse the text then write to column d before moving onto the next row.

Will this be possible to do? How would I go about calling the script?
Can I make excel wait until my script has done its thing before calling the script again with the next row?


The script would ideally accept the text passed to it at the command line like this..

Myscript.py column a column b column c


Many thanks for any help.

The mobile forum app marked this thread as solved. U can't undo it........

Originally Posted by Norie

Could you not do the whole thing in Python?

Dunno.. can I write stuff for excel using python? It's not something I've looked into and I'm nowhere near a computer (typing this on my phone).

I'm just having a bit of a late night brainstorm and wondering what's possible and what's not.
The parsing section of the script is all thought out and um ready to start coding it up. Just unsure how to get excel to interact with it..


Tia

Paul.

Originally Posted by Norie

Paul

As far as I'm aware you can work with Excel via Python.

I don't know too much about it though.

Perhaps this will be of use http://www.python-excel.org/.

Good stuff. Thanks for that.