[python-win32] testMSOffice.py and Excel 2003

Tim Roberts timr at probo.com
Fri Sep 16 21:17:25 CEST 2005

On Thu, 15 Sep 2005 15:24:52 -0400, "Cavanagh, Mike" 
<mike.cavanagh at siemens.com> wrote:

>We have a couple of internal applications that are written in Python and
>have always worked with Excel 2000.
>We are 'upgrading' to Excel 2003 and in my pre-rollout testing, our
>applications are failing.
>Using the testMSOffice.py test case, I receive the following:

>  File "C:\Python24\Lib\site-packages\win32com\test\testMSOffice.py", line
>96, in TextExcel
>    xl.Workbooks().Add()
>  File "C:\Python24\Lib\site-packages\win32com\client\dynamic.py", line 165,
>in __call__
>    return
>com_error: (-2147352562, 'Invalid number of parameters.', None, None)
>I'm beginning to pull my hair out here, any help would be appreciated.

Remove the inner set of parentheses:

Workbooks is a collection object, not a method.

Tim Roberts, timr at probo.com
Providenza & Boekelheide, Inc.

More information about the Python-win32 mailing list