Use macros in Excel via win32com

chris chris.stromberger at gmail.com
Sun Dec 19 02:48:27 CET 2004


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




More information about the Python-list mailing list