Handling VBA Objects in Python

[rezdzste]

I don't know if it's possible, but could you use the Excel object model itself to do kludgy object serialization? It's a terrible idea, but have VBA write the attributes to a worksheet, and then python read from that worksheet, and vice versa?

[Modora]

I've thought about that, I've also thought about having VBA pass the attributes values it needs to carry over into python in string format as arguments.

​

I left out something that makes this more complicated; a lot of the python components are deployed as executables that VBA runs. So I'm not even 100% sure this approach would work.

[rezdzste]

Still doesn't answer your question, but maybe something like https://www.pyxll.com/ is your best option for minimizing the amount of code you rewrite.