[python-win32] Excel win32com newbie question

[Jim Steil]

Oops, obvious typo on the pywin23 below.  Should be pywin32.

	-Jim

-----Original Message-----
From: python-win32-bounces at python.org
[mailto:python-win32-bounces at python.org] On Behalf Of Jim Steil
Sent: Friday, October 06, 2006 11:59 AM
To: 'John Machin'
Cc: python-win32 at python.org
Subject: Re: [python-win32] Excel win32com newbie question

Python 2.4.1
Pywin23 2.10

I'm in the process of upgrading my python to 2.4.3, will send a follow-up
after I'm done testing.

Thanks!

	-Jim

Jim Steil
IT Manager
Quality Liquid Feeds
(608) 935-2345 
(608) 341-9896 cell
-----Original Message-----
From: John Machin [mailto:sjmachin at lexicon.net] 
Sent: Friday, October 06, 2006 10:52 AM
To: Jim Steil
Cc: python-win32 at python.org
Subject: Re: [python-win32] Excel win32com newbie question

On 6/10/2006 11:34 PM, Jim Steil wrote:
> Thanks for your response too!  Unfortunately, I must have something messed
> up here because this didn't work either.
> 
>>>> from win32com.client import Dispatch, constants
>>>> print getattr(constants, 'xlHAlignRight', 'Bzzzzt!')
> Bzzzzt!
>>>> app = Dispatch('Excel.Application')
>>>> print getattr(constants, 'xlHAlignRight', 'Bzzzzt!')
> Bzzzzt!

Yeah well silly me for presuming you had run makepy :-)

> 
> I tried running the makepy.py on the Excell 11.0 Object library and that
> fails on me as well.  Any suggestions?

Tell us a few things you should have supplied w/o being asked:
(1) what version of Python (2.4.what??)
(2) what pywin32 build number
(3) copy/paste of result when you ran makepy

If the makepy gives you a weird syntax error (like the syntax error you 
showed in the response to Tim Roberts), that could be an old bug (in 
Python, I believe). Ensure that you have Python 2.4.3, and the latest 
build of pywin32, and try it again. IIRC, the workaround involved 
editing the file with the syntax error, adding a few spaces to the end 
of the allegedly offending line, and one or two lines before that.

HTH,
John


_______________________________________________
Python-win32 mailing list
Python-win32 at python.org
http://mail.python.org/mailman/listinfo/python-win32