Hi Y'all,

OK, I give up.  I've spent the major part of this Sunday afternoon trying
to learn enough about Active X and Excel so I can improve my current
program for exporting data.  Which works fine just doesn't do every thing I
want.  BTW, my program is a spin off of a PRG written by Randy Howe that he
shared several years ago.

I create the Excel workbook and get data into the active sheet with no
trouble.

I'd like to determine how many sheets are in the book when I create it as
that is determined by the Excel settings which I don't know ahead of time.

Then I'd like to add sheets based on data I'll be exporting and export data
to different sheets.

A jump start will be much appreciated!

    >don<

Op Sun, 19 Sep 2010 19:15:54 -0400 schreef Don Keating:
Don,

I believe oWorkBook:sheets:count  gives you the number of worksheets
currently in the workbook.

Peter

> Hi Y'all,
> 
> OK, I give up.  I've spent the major part of this Sunday afternoon trying
> to learn enough about Active X and Excel so I can improve my current
> program for exporting data.  Which works fine just doesn't do every thing I
> want.  BTW, my program is a spin off of a PRG written by Randy Howe that he
> shared several years ago.
> 
> I create the Excel workbook and get data into the active sheet with no
> trouble.
> 
> I'd like to determine how many sheets are in the book when I create it as
> that is determined by the Excel settings which I don't know ahead of time.
> 
> Then I'd like to add sheets based on data I'll be exporting and export data
> to different sheets.
> 
> A jump start will be much appreciated!
> 
>     >don<

Thanks Peter!

That much got me off dead center and moving again.

Don't have everything working like I want but, at least I'm making
progress.

I have a real problem understanding the Visual Basic syntax so I can
"convert" it to XPP.

   >don<

On Tue, 21 Sep 2010 16:53:42 +0200, Peter Alderliesten wrote:

> Op Sun, 19 Sep 2010 19:15:54 -0400 schreef Don Keating:
> Don,
> 
> I believe oWorkBook:sheets:count  gives you the number of worksheets
> currently in the workbook.
> 
> Peter
> 
> > Hi Y'all,
> > 
> > OK, I give up.  I've spent the major part of this Sunday afternoon
trying
> > to learn enough about Active X and Excel so I can improve my current
> > program for exporting data.  Which works fine just doesn't do every
thing I
> > want.  BTW, my program is a spin off of a PRG written by Randy Howe
that he
> > shared several years ago.
> > 
> > I create the Excel workbook and get data into the active sheet with no
> > trouble.
> > 
> > I'd like to determine how many sheets are in the book when I create it
as
> > that is determined by the Excel settings which I don't know ahead of
time.
> > 
> > Then I'd like to add sheets based on data I'll be exporting and export
data
> > to different sheets.
> > 
> > A jump start will be much appreciated!
> > 
> >     >don<

Don,

> I have a real problem understanding the Visual Basic syntax so I can
> "convert" it to XPP.

Show us something, there are certainly more of us that have been down that
road and will be able to help you.

Peter