win32com problems with Visible property

[Rebecca Taylor]

I have been working with win32com on python for 2 years now. I
recently tried to modify an older script I had made which creates and
excel workbook, fills it with data and then graphs the data.

Nothing is working!
When I try to run it I get this error:

"Property '%s.%s' can not be set." % (self._username_, attr)
AttributeError: Property 'Excel.Application.visible' can not be set."

Does anyone know why this is happening? I can't figure out if windows
has changed or if win32all or the new python distribution is the
problem. Worse yet, I reinstalled my old versions of python and
win32all and that isn't working either!

Thanks in advance.
-rebecca

 

[Peter Hansen]

I have been working with win32com on python for 2 years now. I
recently tried to modify an older script I had made which creates and
excel workbook, fills it with data and then graphs the data.

Nothing is working!
When I try to run it I get this error:

"Property '%s.%s' can not be set." % (self._username_, attr)
AttributeError: Property 'Excel.Application.visible' can not be set."

Does anyone know why this is happening? I can't figure out if windows
has changed or if win32all or the new python distribution is the
problem. Worse yet, I reinstalled my old versions of python and
win32all and that isn't working either!

I'm not sure what the problem is, but cutting and pasting the *actual*
traceback instead of retyping might help us find it, or at least would
help us trust everything you're saying. Not having 100% confidence
in a problem report (as in this case) tends to make one investigate
less intensely, I've found...

-Peter

 

[David Rushby]

I have been working with win32com on python for 2 years now. I
recently tried to modify an older script I had made which creates and
excel workbook, fills it with data and then graphs the data.

Nothing is working!
When I try to run it I get this error:

"Property '%s.%s' can not be set." % (self._username_, attr)
AttributeError: Property 'Excel.Application.visible' can not be set."

Does anyone know why this is happening? I can't figure out if windows
has changed or if win32all or the new python distribution is the
problem. Worse yet, I reinstalled my old versions of python and
win32all and that isn't working either!

The property is named 'Visible', not 'visible'.

When makepy is run, COM identifiers become case-sensitive. Perhaps your old
installation of win32com hadn't been makepy-ified, but the new one has?

See:
http://groups.google.com/groups?q=e...=UTF-8&group=comp.lang.python.*&safe=off&sa=G

http://groups.google.com/[email protected]#link
13

 

[Bob Gailer]

The property is named 'Visible', not 'visible'.

When makepy is run, COM identifiers become case-sensitive. Perhaps your old
installation of win32com hadn't been makepy-ified, but the new one has?

I don't think this is the problem. If it were the OP would get an attribute
error. "...object has no attribute 'visible'"

Bob Gailer
(e-mail address removed)
303 442 2625