Name of the objects and Object types

Hi,

I have primarily used Excel (with a little VB).
This is my introduction to powerpoint.

I am copying some ranges (containing some text) from Excel and pasting in to
powerpoint.

I want to copy this text from excel and paste it within a specific textbox
within a powerpoint template.

How do I know the name of the textbox in the powerpoint template.

I see that if I run some dummy macro recording's then I get some code like
ActiveWindow.Selection.SlideRange.Shapes("Text Box 8").Select

Is there a more efficient way of knowing the name of the objects and object
numbers in powerpoint(rather than recording macros for each object and
seeing the description inside Shapes("Text Box 8"). )

Also, is there a separate group for powerpoint programming? (My OE doesnt
say so)

Thanks a lot,
Hari
India

Hari,
You don't need to know the name of the shape enter text into it. You can use
the index number of the shape too.
ActiveWindow.Selection.SlideRange.Shapes(1).TextFr ame.TextRange.Text = "This
is a test.
' Assuming that you intend to paste the text from the clipboard.
ActiveWindow.Selection.ShapeRange(1).TextFrame.Tex tRange.Paste

I would recommend that you spend some time visiting the pages at the
following sites: http://skp.mvps.org and the programming section of the
PowerPoint Faq - www.pptfaq.com

--
Regards,
Shyam Pillai

Handout Wizard: http://skp.mvps.org/how




"Hari Prasadh" wrote in message
...
Hi,

I have primarily used Excel (with a little VB).
This is my introduction to powerpoint.

I am copying some ranges (containing some text) from Excel and pasting in
to powerpoint.

I want to copy this text from excel and paste it within a specific textbox
within a powerpoint template.

How do I know the name of the textbox in the powerpoint template.

I see that if I run some dummy macro recording's then I get some code like
ActiveWindow.Selection.SlideRange.Shapes("Text Box 8").Select

Is there a more efficient way of knowing the name of the objects and
object numbers in powerpoint(rather than recording macros for each object
and seeing the description inside Shapes("Text Box 8"). )

Also, is there a separate group for powerpoint programming? (My OE doesnt
say so)

Thanks a lot,
Hari
India

What Shyam said (I would never disagree with Shyam since he knows more about
his than anyone) and...

If you really want to know the name of a shape, you can get it with some
simple macros. See Example 8.7 on my site:

http://www.loyola.edu/education/PowerfulPowerPoint/

Just click on Examples by Chapter and Chapter 8.

--David

David Marcovitz
Author of _Powerful PowerPoint for Educators_
http://www.loyola.edu/education/PowerfulPowerPoint/

"Shyam Pillai" wrote:

Hari,
You don't need to know the name of the shape enter text into it. You can use
the index number of the shape too.
ActiveWindow.Selection.SlideRange.Shapes(1).TextFr ame.TextRange.Text = "This
is a test.
' Assuming that you intend to paste the text from the clipboard.
ActiveWindow.Selection.ShapeRange(1).TextFrame.Tex tRange.Paste

I would recommend that you spend some time visiting the pages at the
following sites: http://skp.mvps.org and the programming section of the
PowerPoint Faq - www.pptfaq.com

--
Regards,
Shyam Pillai

Handout Wizard: http://skp.mvps.org/how




"Hari Prasadh" wrote in message
...
Hi,

I have primarily used Excel (with a little VB).
This is my introduction to powerpoint.

I am copying some ranges (containing some text) from Excel and pasting in
to powerpoint.

I want to copy this text from excel and paste it within a specific textbox
within a powerpoint template.

How do I know the name of the textbox in the powerpoint template.

I see that if I run some dummy macro recording's then I get some code like
ActiveWindow.Selection.SlideRange.Shapes("Text Box 8").Select

Is there a more efficient way of knowing the name of the objects and
object numbers in powerpoint(rather than recording macros for each object
and seeing the description inside Shapes("Text Box 8"). )

Also, is there a separate group for powerpoint programming? (My OE doesnt
say so)

Thanks a lot,
Hari
India

Hi Shyam,

I have gone through your site and found syntaxes in the newbie section
useful to me.

My following question would be a very naive one for you. You have asked me
to use the index number of the shape. How would it be possible for me to
know the index number of the shape non-programmatically. Please guide me.

Analogy is that in Excel if I have a embedded chart and if I keep the Ctrl
pressed and select one of the chart, Name-Box would say Chart 1 or Chart 2.
Do we have such Name-Boxes in Power-point?

(Please note , programmatically I have been able to know the index number of
the shape in an indirect manner by using the Sub
Object_Types_on_This_Slide() from rpdslides.com -- FullFaq's list)

Thanks a lot,
Hari
India

"Shyam Pillai" wrote in message
...
Hari,
You don't need to know the name of the shape enter text into it. You can
use the index number of the shape too.
ActiveWindow.Selection.SlideRange.Shapes(1).TextFr ame.TextRange.Text =
"This is a test.
' Assuming that you intend to paste the text from the clipboard.
ActiveWindow.Selection.ShapeRange(1).TextFrame.Tex tRange.Paste

I would recommend that you spend some time visiting the pages at the
following sites: http://skp.mvps.org and the programming section of the
PowerPoint Faq - www.pptfaq.com

--
Regards,
Shyam Pillai

Handout Wizard: http://skp.mvps.org/how

Hi Shyam,

Im sorry. Even programmatically Im not able to find the shape number --
Shapes(1) -- as the macro Object_Types_on_This_Slide() from rpdslides.com
gives me the type number and the name of the object but not the shape
number.

Please tell me the syntax for finding the shape number of an object
programmatically. (also for finding the same non-programmatically)

Thanks a lot,
Hari
India


"Hari Prasadh" wrote in message
...
Hi Shyam,

I have gone through your site and found syntaxes in the newbie section
useful to me.

My following question would be a very naive one for you. You have asked me
to use the index number of the shape. How would it be possible for me to
know the index number of the shape non-programmatically. Please guide me.

Analogy is that in Excel if I have a embedded chart and if I keep the Ctrl
pressed and select one of the chart, Name-Box would say Chart 1 or Chart
2. Do we have such Name-Boxes in Power-point?

(Please note , programmatically I have been able to know the index number
of the shape in an indirect manner by using the Sub
Object_Types_on_This_Slide() from rpdslides.com -- FullFaq's list)

Thanks a lot,
Hari
India

Hari,
The index number corresponds to the z-order position of the shape on the
slide. The bottom most shape will have the index as 1 and the top most shape
as N where N = number of shapes on the slide. You can ascertain the index
number by making use of a hidden utility - Select Multiple Object.

1. Select Tools | Customize..| Commands Tab.
2. Under catergories click on 'Drawing'.
3. Draw 'Select Multiple Objects' command from the right column to a toolbar
of your choice.
4. Close the Customize dialog.
5. Click on the new command button you've added.

This will enumerate the shape in order of their index numbers.

Do we have such Name-Boxes in Power-point?
Not quite, but you can download my free rename add-in which has a name box.
Download it from he http://skp.mvps.org/download.htm

--
Regards,
Shyam Pillai

Handout Wizard: http://skp.mvps.org/how



"Hari Prasadh" wrote in message
...
Hi Shyam,

I have gone through your site and found syntaxes in the newbie section
useful to me.

My following question would be a very naive one for you. You have asked me
to use the index number of the shape. How would it be possible for me to
know the index number of the shape non-programmatically. Please guide me.

Analogy is that in Excel if I have a embedded chart and if I keep the Ctrl
pressed and select one of the chart, Name-Box would say Chart 1 or Chart
2. Do we have such Name-Boxes in Power-point?

(Please note , programmatically I have been able to know the index number
of the shape in an indirect manner by using the Sub
Object_Types_on_This_Slide() from rpdslides.com -- FullFaq's list)

Thanks a lot,
Hari
India

"Shyam Pillai" wrote in message
...
Hari,
You don't need to know the name of the shape enter text into it. You can
use the index number of the shape too.
ActiveWindow.Selection.SlideRange.Shapes(1).TextFr ame.TextRange.Text =
"This is a test.
' Assuming that you intend to paste the text from the clipboard.
ActiveWindow.Selection.ShapeRange(1).TextFrame.Tex tRange.Paste

I would recommend that you spend some time visiting the pages at the
following sites: http://skp.mvps.org and the programming section of the
PowerPoint Faq - www.pptfaq.com

--
Regards,
Shyam Pillai

Handout Wizard: http://skp.mvps.org/how

Hi Shyam,

Im sorry .. -- shapes(i) -- is there in the code of
Object_Types_on_This_Slide() from rpdslides.com
So Im able to find the shape number programmatically by using -- Msgbox i --

Thanks a lot,
Hari
India

"Hari Prasadh" wrote in message
...
Hi Shyam,

Im sorry. Even programmatically Im not able to find the shape number --
Shapes(1) -- as the macro Object_Types_on_This_Slide() from rpdslides.com
gives me the type number and the name of the object but not the shape
number.

Please tell me the syntax for finding the shape number of an object
programmatically. (also for finding the same non-programmatically)

Thanks a lot,
Hari
India


"Hari Prasadh" wrote in message
...
Hi Shyam,

I have gone through your site and found syntaxes in the newbie section
useful to me.

My following question would be a very naive one for you. You have asked
me to use the index number of the shape. How would it be possible for me
to know the index number of the shape non-programmatically. Please guide
me.

Analogy is that in Excel if I have a embedded chart and if I keep the
Ctrl pressed and select one of the chart, Name-Box would say Chart 1 or
Chart 2. Do we have such Name-Boxes in Power-point?

(Please note , programmatically I have been able to know the index number
of the shape in an indirect manner by using the Sub
Object_Types_on_This_Slide() from rpdslides.com -- FullFaq's list)

Thanks a lot,
Hari
India

Hi Shyam,

Select Multiple Object is a nice method to know about the index number.

But based on your -- The bottom most shape will have the index as 1 and the
top most shape as N where N = number of shapes on the slide. -- I have new
doubts.

In the first slide of my presentation I have 3 shapes and all these 3 are
text-boxes.

When I click on the Select multiple objects, then I have 3 checkboxes within
that:-
Text Box 8: Hello
Text Box 9: World
Text Box 10: Bye

My doubt is that if there are only 3 shapes then why are the numbers above
8, 9 and 10 instead of 1, 2 and 3?
Morever the text in the top most text-box is hello, while the text in the
middle text-box is world and the text in the third text-box is Bye. So why
is the select multiple option utility giving a higher number to the
bottom-most text-box.

(I have Office XP and Win XP.)

Thanks a lot,
Hari
India
"Shyam Pillai" wrote in message
...
Hari,
The index number corresponds to the z-order position of the shape on the
slide. The bottom most shape will have the index as 1 and the top most
shape as N where N = number of shapes on the slide. You can ascertain the
index number by making use of a hidden utility - Select Multiple Object.

1. Select Tools | Customize..| Commands Tab.
2. Under catergories click on 'Drawing'.
3. Draw 'Select Multiple Objects' command from the right column to a
toolbar of your choice.
4. Close the Customize dialog.
5. Click on the new command button you've added.

This will enumerate the shape in order of their index numbers.

Do we have such Name-Boxes in Power-point?
Not quite, but you can download my free rename add-in which has a name
box. Download it from he http://skp.mvps.org/download.htm

--
Regards,
Shyam Pillai

Handout Wizard: http://skp.mvps.org/how



"Hari Prasadh" wrote in message
...
Hi Shyam,

I have gone through your site and found syntaxes in the newbie section
useful to me.

My following question would be a very naive one for you. You have asked
me to use the index number of the shape. How would it be possible for me
to know the index number of the shape non-programmatically. Please guide
me.

Analogy is that in Excel if I have a embedded chart and if I keep the
Ctrl pressed and select one of the chart, Name-Box would say Chart 1 or
Chart 2. Do we have such Name-Boxes in Power-point?

(Please note , programmatically I have been able to know the index number
of the shape in an indirect manner by using the Sub
Object_Types_on_This_Slide() from rpdslides.com -- FullFaq's list)

Thanks a lot,
Hari
India

"Shyam Pillai" wrote in message
...
Hari,
You don't need to know the name of the shape enter text into it. You can
use the index number of the shape too.
ActiveWindow.Selection.SlideRange.Shapes(1).TextFr ame.TextRange.Text =
"This is a test.
' Assuming that you intend to paste the text from the clipboard.
ActiveWindow.Selection.ShapeRange(1).TextFrame.Tex tRange.Paste

I would recommend that you spend some time visiting the pages at the
following sites: http://skp.mvps.org and the programming section of the
PowerPoint Faq - www.pptfaq.com

--
Regards,
Shyam Pillai

Handout Wizard: http://skp.mvps.org/how

Hi David,

Thnx a ton for the link.

I went through all the example powerpoint files in your site and pinched
some of the syntaxes in them for my needs.

Regards,
Hari
India

"David M. Marcovitz" wrote in
message ...
What Shyam said (I would never disagree with Shyam since he knows more
about
his than anyone) and...

If you really want to know the name of a shape, you can get it with some
simple macros. See Example 8.7 on my site:

http://www.loyola.edu/education/PowerfulPowerPoint/

Just click on Examples by Chapter and Chapter 8.

--David

David Marcovitz
Author of _Powerful PowerPoint for Educators_
http://www.loyola.edu/education/PowerfulPowerPoint/

Hi Shyam,

I see that Select multiple objects is a GREAT way to select *hidden*
objects. Like I was just playing around and had a rectangle and over it I
created a big table which hid the rectangle from view and using the multiple
object view I could select the rectangle and edit the Text in that.

Just wanted to know this. Is there any other non-programmatic way to
accomplish the above. (Programmatically I can do it based on swiping codes
from here and there.)

Thanks a lot,
Hari
India

"Shyam Pillai" wrote in message
...
Hari,
The index number corresponds to the z-order position of the shape on the
slide. The bottom most shape will have the index as 1 and the top most
shape as N where N = number of shapes on the slide. You can ascertain the
index number by making use of a hidden utility - Select Multiple Object.

1. Select Tools | Customize..| Commands Tab.
2. Under catergories click on 'Drawing'.
3. Draw 'Select Multiple Objects' command from the right column to a
toolbar of your choice.
4. Close the Customize dialog.
5. Click on the new command button you've added.

This will enumerate the shape in order of their index numbers.

Do we have such Name-Boxes in Power-point?
Not quite, but you can download my free rename add-in which has a name
box. Download it from he http://skp.mvps.org/download.htm

--
Regards,
Shyam Pillai

Handout Wizard: http://skp.mvps.org/how



"Hari Prasadh" wrote in message
...
Hi Shyam,

I have gone through your site and found syntaxes in the newbie section
useful to me.

My following question would be a very naive one for you. You have asked
me to use the index number of the shape. How would it be possible for me
to know the index number of the shape non-programmatically. Please guide
me.

Analogy is that in Excel if I have a embedded chart and if I keep the
Ctrl pressed and select one of the chart, Name-Box would say Chart 1 or
Chart 2. Do we have such Name-Boxes in Power-point?

(Please note , programmatically I have been able to know the index number
of the shape in an indirect manner by using the Sub
Object_Types_on_This_Slide() from rpdslides.com -- FullFaq's list)

Thanks a lot,
Hari
India

"Shyam Pillai" wrote in message
...
Hari,
You don't need to know the name of the shape enter text into it. You can
use the index number of the shape too.
ActiveWindow.Selection.SlideRange.Shapes(1).TextFr ame.TextRange.Text =
"This is a test.
' Assuming that you intend to paste the text from the clipboard.
ActiveWindow.Selection.ShapeRange(1).TextFrame.Tex tRange.Paste

I would recommend that you spend some time visiting the pages at the
following sites: http://skp.mvps.org and the programming section of the
PowerPoint Faq - www.pptfaq.com

--
Regards,
Shyam Pillai

Handout Wizard: http://skp.mvps.org/how