Another PythonWin Excel question
It's me
itsme at yahoo.com
Thu Jan 6 20:58:51 EST 2005
Yes, Mike,
Others pointed that out as well.
The difficulty is that they are all in VBAs. Most of them can be
translated to Python fairly easily, and some I can get from looking at the
recorded macro - but some requires quite a bit of head scratching.
For instance, I wanted to figure out how create a new window. So, I went
through the record macro process and looked at the VBA code, it says:
ActiveWindow.NewWindow
Okay. Now what???
And for switching window, it says:
Windows("Book1:1").Activate
Okay. ???
So, I look through the online information on msdn and viola! No mentioning
of that anwhere....
Would be nice if there's a Python specific of it....but just dreaming...
Back to reading MSDN.....
Thanks,
"Mike Thompson" <none.by.e-mail> wrote in message
news:41ddb59e$0$8338$afc38c87 at news.optusnet.com.au...
> It's me wrote:
> > I followed the example in
> > http://stompstompstomp.com/weblog/technical/2004-05-20 and learned that
to
> > add a new worksheet to an Excel workbook, you would use the
> > workbook.Worksheets.Add() method. That works. However, the new
worksheet
> > got added *in front* of the last worksheet I was at. How can I get it
to
> > add *after*?
> >
> > Thanks,
> >
> > --
> > Me
> >
> >
>
> Does this help?
>
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_wrcore/html/wrtskhowtomoveworksheetswithinworkbooks.asp
>
> --
> Mike
More information about the Python-list
mailing list