PowerPoint Object in Excel Macro

**SmartS.101** · 07-30-2009, 07:54 AM

I am trying to make a Macro that takes the information in PowerPoint files and copy/pastes them into an Excel File to be read/compared faster. I need a way to select the objects (mostly text boxes) based NOT on the PowerPoint Object number, but location on the slide. I know how to move them around using a Macro but it will not give the starting location in this manner.
Thanks in advance.

**romperstomper** · 07-30-2009, 08:15 AM

Could you be a bit more specific about this? In terms of location, how would you know what's what? Based on the Left or Top properties, or relative to some other object, or what?

**SmartS.101** · 07-30-2009, 08:21 AM

Actually I'm not really sure, that's where I'm running into problems. Since I don't know the location of any of the objects, the other seems like it would be more helpful.
I was kind of hoping there was a way where a scanner type something would read the slide (similar to a disk) and when it saw the one with the right title it would copy/paste it where it needs to go.

**romperstomper** · 07-30-2009, 08:28 AM

Powerpoint's not really my thing, but you can read the title of a slide using code like this (objSlide is a Slide!):

objSlide.Shapes.Title.TextFrame.TextRange.Text

**DonkeyOte** · 07-30-2009, 08:47 AM

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

http://www.mrexcel.com/forum/showthread.php?t=406320

**Andy Pope** · 07-30-2009, 08:49 AM

You can automate ppt from excel reading all the shapes on all the slides.

How do you know which ones to process though, are there key words to search for?

Perhaps posting an example file might help

**SmartS.101** · 07-30-2009, 09:29 AM

...about that. One slide of the show is 25kb in Word and 1.7Mb as a picture(jpeg or bmp), well over these ridiculous limits for file size.
Basicly the title is across the top of the slide, off center to the left. There are four boxes: Strengths, Weaknesses, Focus Areas, and Paths to Green. They are in pairs going across the middle and middle-bottom of the slide respectively. Across the bottom is the "Overall Assesment" label and the corresponding circle (G/Y/R). In each of the four text boxes there are two to four bullets. These contain the info needed to be placed into the excel sheet.