[python-win32] Showing/Selecting Excel sheets
Colin Campbell
ccampbell@ede.org
Thu, 04 Jul 2002 11:09:14 -0600
--=====================_9907687==_.ALT
Content-Type: text/plain; charset="us-ascii"; format=flowed
At 10:35 AM 7/04/02, Mark Ainsworth wrote:
>Subtle but:
>
>wkb.Sheets(2).Select() # show me sheet 2
>
>works for me. Notice the Select().
Works for me, too. Bless you!
Do I gather that as a general principle, things which look like methods in
VBA , such as "WorkBook.Sheets(2).Select " need to look like functions
when called from Python via COM, or is there something else I'm missing?
TIA
Colin
Patience serves as a protection against wrongs as clothes do against cold.
For if you put on more clothes as the cold increases, it will have no power
to hurt you. So in like manner you must grow in patience when you meet with
great wrongs, and they will then be powerless to vex your mind.
-Leonardo da Vinci, painter, engineer, musician, and scientist (1452-1519)
--=====================_9907687==_.ALT
Content-Type: text/html; charset="us-ascii"
<html>
<font size=3>At 10:35 AM 7/04/02, Mark Ainsworth wrote:<br>
<blockquote type=cite class=cite cite>Subtle but:<br><br>
wkb.Sheets(2).Select()
# show me sheet 2<br><br>
works for me. Notice the Select().</blockquote><br>
</font>Works for me, too. Bless you!<br>
Do I gather that as a general principle, things which look like methods
in VBA , such as "WorkBook.Sheets(2).Select " need to
look like functions when called from Python via COM, or is there
something else I'm missing? <br>
<font size=3>TIA<br>
Colin<br><br>
<x-sigsep><p></x-sigsep>
Patience serves as a protection against wrongs as clothes do against
cold.<br>
For if you put on more clothes as the cold increases, it will have no
power<br>
to hurt you. So in like manner you must grow in patience when you meet
with<br>
great wrongs, and they will then be powerless to vex your mind.<br>
-Leonardo da Vinci, painter, engineer, musician, and
scientist (1452-1519)</font></html>
--=====================_9907687==_.ALT--