Use macros in Excel via win32com

[Gregor Horvath]

chris wrote:
> 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.

Make a xla in Excel including your VBA macro first and then create your 
spreadshet from python using that xla as template.

--
Greg