• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 207
  • Last Modified:

Cycle through shapes

What's wrong here...?

For Each Shp In PPPres.Slides(1).Shapes
  MsgBox Shp.Name & Shp.Type
Next
0
UINVDJM
Asked:
UINVDJM
  • 4
  • 3
  • 3
1 Solution
 
mvidasCommented:
Seems ok.. is it throwing any errors at you?
You could try checking to see if the .shapes.count>0

Since you're running this from excel, have you tried Dim'ming the Shp as Powerpoint.Shape? Maybe you just used Shape and the excel.shape <> powerpoint.shape ?

Just a thought
0
 
GrahamSkanRetiredCommented:
Nothing in itself. Why do you think that there might be?
0
 
GrahamSkanRetiredCommented:
Maybe you have 'Option Explicit' missing
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
UINVDJMAuthor Commented:
Bang on again Matt...

"Shp as Powerpoint.Shape"

I just had "Shape" as you say.
0
 
mvidasCommented:
Glad to help, again!  Now will you stop asking 500 point questions that only take a minute to answer :)
0
 
UINVDJMAuthor Commented:
It says difficult or urgent...I have nothing else to do and to save me being bored I classify them as urgent! :)

Anyway. All done now! No more points today!
0
 
mvidasCommented:
LOL, we'll be here when you need us :)
0
 
GrahamSkanRetiredCommented:
It takes more than that to answer if the question is incomplete.
0
 
UINVDJMAuthor Commented:
Graham, yes I realise that. I tried to keep the question concise.
If I'd known the answer I probably could have written the question far better. Credit to Matt for second-guessing me.

My sincere apologies.
0
 
GrahamSkanRetiredCommented:
OK Darren, your graceful apologies certainly accepted on behalf of anyone who would have been confused.

For your guidance, if you get an error message, tell us what it is and where you get it. In your case, I guess it was: "Run time error 438, Property doesn't support this property or method".

In this case, the context would also have been useful: that you were using early binding to connect to PowerPoint in an Excel macro.  Correct that; it was essential.

I see that Matt had already answered several of  questions on your project, so was in a position to realise what was happening.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now