Calling python code from VSTO excel addin

Question

I am working on an excel2007 plugin in VSTO and am using VB for coding it. One of the item in the plugin is the button, pressing which should give a call to a python program which will add some data to the current worksheet. I would like to know 1 How can i call the python function from the VBA code 2 pass the active workbook to this code?

Answer 1

you can use PyXLL to call a python function from Excel either as a worksheet function or as a macro which you can call from VBA. If you look at the docs for xl_macro on the PyXLL website you'll find an example of how to do that.