shape index values - how do I get them?

Peter Webb wrote:

Quote: I have created two sets of circles using addshape, innercircle(i) and outercircle(i), and I want to group them in pairs so innercircle(1) and outercircle(1) are grouped, etc. I am supposed to be able to use the shapes.range(array()).group command to do this. > This works if I just stick numbers in at random, but I actually want to put in the index numbers for innercircle(i) and outercircle(i). I have tried everything I can think of. > How do I get the index value for a specific shape, like innercircle (1) or outercircle(2) ???

I guess you are referring to one of the Office apps as none of that is
in Visual Basic natively.
You may want to check one of the Office or vba groups under the
Microsoft.Public hierarchy.

--
Dean Earley (dean.earley@icode.co.uk)
i-Catcher Development Team

iCode Systems

"Dean Earley" <dean.earley@icode.co.ukwrote in message
news:46dbe4cd$0$13935$fa0fcedb@news.zen.co.uk...

Quote: Peter Webb wrote: Quote: >I have created two sets of circles using addshape, innercircle(i) and >outercircle(i), and I want to group them in pairs so innercircle(1) and >outercircle(1) are grouped, etc. I am supposed to be able to use the >shapes.range(array()).group command to do this. >> >This works if I just stick numbers in at random, but I actually want to >put in the index numbers for innercircle(i) and outercircle(i). I have >tried everything I can think of. >> >How do I get the index value for a specific shape, like innercircle (1) >or outercircle(2) ??? > I guess you are referring to one of the Office apps as none of that is in Visual Basic natively. You may want to check one of the Office or vba groups under the Microsoft.Public hierarchy. >

Yeah ... I want to control powerpoint with Excel, drawing slides using
powerpoint.

I've got the graphics happening in Excel, but I want them on slides.

Now I have a different problem, which (I'm sorry I have nowhere else to
turn) is as follows.

I include the powerpoint class libraries, and they have their own shape
libraries, which are exactly the same except they draw on a slide. However,
I now have two subtly different classes, both called "shape". When I key in

Dim abc As Shape

I get two choices for "Shape", and I seem to have no idea which class I have
created. Is there some way to force it to use the class I want?

Peter Webb wrote:

Quote: Yeah ... I want to control powerpoint with Excel, drawing slides using powerpoint. > I've got the graphics happening in Excel, but I want them on slides. > Now I have a different problem, which (I'm sorry I have nowhere else to turn) is as follows. > I include the powerpoint class libraries, and they have their own shape libraries, which are exactly the same except they draw on a slide. However, I now have two subtly different classes, both called "shape". When I key in > Dim abc As Shape > I get two choices for "Shape", and I seem to have no idea which class I have created. Is there some way to force it to use the class I want?

You will need to qualify them with a library name, which I THINK (I
don't use Office or VBA) are Excel and PowerPoint.

Dim abc As Excel.Shape

--
Dean Earley (dean.earley@icode.co.uk)
i-Catcher Development Team

iCode Systems

"Dean Earley" <dean.earley@icode.co.ukwrote in message
news:46dd60ec$0$13924$fa0fcedb@news.zen.co.uk...

Quote: Peter Webb wrote: Quote: >Yeah ... I want to control powerpoint with Excel, drawing slides using >powerpoint. >> >I've got the graphics happening in Excel, but I want them on slides. >> >Now I have a different problem, which (I'm sorry I have nowhere else to >turn) is as follows. >> >I include the powerpoint class libraries, and they have their own shape >libraries, which are exactly the same except they draw on a slide. >However, I now have two subtly different classes, both called "shape". >When I key in >> >Dim abc As Shape >> >I get two choices for "Shape", and I seem to have no idea which class I >have created. Is there some way to force it to use the class I want? > You will need to qualify them with a library name, which I THINK (I don't use Office or VBA) are Excel and PowerPoint. > Dim abc As Excel.Shape > -- Dean Earley (dean.earley@icode.co.uk) i-Catcher Development Team > iCode Systems

Simple and obvious enough to be true.

I will try it tonight.

I haven't programmed in over 30 years, and even then it was assembly
language programming for microprocessors (6502, PDP11 etc). Its a bit of a
jump to go from INC and BNE instructions to class libraries in one go. Fun
and interesting, though.

Thanks for your help.

Peter Webb

"Dean Earley" <dean.earley@icode.co.ukwrote in message
news:46dd60ec$0$13924$fa0fcedb@news.zen.co.uk...

Quote: Peter Webb wrote: Quote: >Yeah ... I want to control powerpoint with Excel, drawing slides using >powerpoint. >> >I've got the graphics happening in Excel, but I want them on slides. >> >Now I have a different problem, which (I'm sorry I have nowhere else to >turn) is as follows. >> >I include the powerpoint class libraries, and they have their own shape >libraries, which are exactly the same except they draw on a slide. >However, I now have two subtly different classes, both called "shape". >When I key in >> >Dim abc As Shape >> >I get two choices for "Shape", and I seem to have no idea which class I >have created. Is there some way to force it to use the class I want? > You will need to qualify them with a library name, which I THINK (I don't use Office or VBA) are Excel and PowerPoint. > Dim abc As Excel.Shape >

I have no idea why I didn't work this out for myself. It worked brilliantly.
Thankyou.