Re: Use macros in Excel via win32com

2004-12-20 Thread chris
This makes sense. Thanks for the ideas. -- http://mail.python.org/mailman/listinfo/python-list

Re: Use macros in Excel via win32com

2004-12-19 Thread Harald Massa
chris, > 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 recommend to create the excel document not from scratch

Re: Use macros in Excel via win32com

2004-12-18 Thread chris
Thanks, but the problem is that I need to create the entire Excel document from scratch, dynamically, via the Python script. I want the script to add the macro code. -Chris -- http://mail.python.org/mailman/listinfo/python-list

Re: Use macros in Excel via win32com

2004-12-18 Thread 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 th

Re: Use macros in Excel via win32com

2004-12-18 Thread [EMAIL PROTECTED]
"chris" <[EMAIL PROTECTED]> 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 on

Use macros in Excel via win32com

2004-12-18 Thread chris
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