• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 205
  • 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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