By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,587 Members | 1,101 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,587 IT Pros & Developers. It's quick & easy.

shape index values - how do I get them?

P: n/a
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

Sep 1 '07 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Peter Webb wrote:
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 (de*********@icode.co.uk)
i-Catcher Development Team

iCode Systems
Sep 3 '07 #2

P: n/a

"Dean Earley" <de*********@icode.co.ukwrote in message
news:46***********************@news.zen.co.uk...
Peter Webb wrote:
>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?
Sep 4 '07 #3

P: n/a
Peter Webb wrote:
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 (de*********@icode.co.uk)
i-Catcher Development Team

iCode Systems
Sep 4 '07 #4

P: n/a

"Dean Earley" <de*********@icode.co.ukwrote in message
news:46***********************@news.zen.co.uk...
Peter Webb wrote:
>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 (de*********@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

Sep 5 '07 #5

P: n/a

"Dean Earley" <de*********@icode.co.ukwrote in message
news:46***********************@news.zen.co.uk...
Peter Webb wrote:
>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.
Sep 5 '07 #6

This discussion thread is closed

Replies have been disabled for this discussion.