Python and VBA

[Kevin Nowaczyk]

I thought I’d pass on a couple projects I’m working on that people here may be interested in. I have a python project that is able to assemble and disassemble VBA code to and from a VbaProject.bin file. This project might find it useful for exposing the embedded VBA code in a spreadsheet to a user, or to allow a user to edit the VBA and then create a new VbaProject.bin from the source code.

GitHub.com/Beakerboy/MS-OVBA

I’m also working on a VBA interpreter using Python and ANTLR. If that gets more attention, the VBA macros in a spreadsheet could trigger from actions that take place in this project.

GitHub.com/Beakerboy/PyVBA-Interpreter

Happy to have more eyes or help on these endeavors.

Kevin Nowaczyk