Another PythonWin Excel question

It's me itsme at yahoo.com
Fri Jan 7 02:58:51 CET 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