[python-win32] Range('A:A,D:D,G:G') in excel

Hello. I have a little problem with this instruction. If i run a macro in excel (Office 2003 SP1) to select 3 columns for exemple, the code in VB is : Range('A:A,D:D,G:G') But if I try this in python, I have a beautiful traceback : excel.ActiveSheet.Range('A:A,D:D,G:G') Traceback (most recent

Re: [python-win32] Range('A:A,D:D,G:G') in excel

> If i run a macro in excel (Office 2003 SP1) to select 3 columns for > exemple, the code in VB is : > Range('A:A,D:D,G:G') > > But if I try this in python, I have a beautiful traceback : > excel.ActiveSheet.Range('A:A,D:D,G:G') I don't know why, but if I change the ',' by ';' it's ok ! Sylvain

[python-win32] Problem passing a VARIANT argument to a method of a COM object

Hi everyone, I am struggling with a problem related to passing a VARIANT argument to a COM object. I am getting this exception: TypeError: The VARIANT type is unknown (001e) Here's what I am trying to execute: - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Python 2.