shape index values - how do I get them? 
September 1st, 2007, 04:35 PM
| | | |
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) ???
Thanks - I am going crazy
|
September 3rd, 2007, 11:45 AM
| | | | re: 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 |
September 4th, 2007, 02:45 PM
| | | | re: shape index values - how do I get them?
"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? |
September 4th, 2007, 02:45 PM
| | | | re: shape index values - how do I get them?
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 |
September 5th, 2007, 07:15 AM
| | | | re: shape index values - how do I get them?
"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 |
September 5th, 2007, 11:55 AM
| | | | re: shape index values - how do I get them?
"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. |  |
| | |  /bytes/about
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 225,662 network members.
|
