I'm creating an excel document dynamically from scratch using Python and the win32com module. All is well, but now I need to add a macro to the spreadsheet and run it (to enable some sorting features in the spreadsheet). I think I know how to run a macro once it's installed (using the Run method of the excel application object...I think), but I can't figure out how to "install" the VBA macro code into the spreadsheet to begin with from my Python script. Any tips appreciated.
Thanks, Chris -- http://mail.python.org/mailman/listinfo/python-list
