How can I Transfer Data from Powerpoint to Excel?

Hi -

I'm not much of an expert on Power Point. It seems like the slides would have had to been set up with the text boxes named as each category you are trying to extract. For example, the text box that contains the person's title would have to have either been named "Title" OR in all of you slides, the title is ALWAYS in text box 2 or 3 or whatever order the slides were created. Then, you would need some kind of VBA code to open each power point file and extract the text from each named text box. Again, this is beyond my ability.

I did a quick google search and you can try this link:

http://www.pptfaq.com/FAQ00950_Expor...Excel_file.htm

That will export the information to a CSV file that you can import and parse in Excel.

Good luck.

Here is my shot at it. If you open the powerpoint presentation and click on a box and go to Format -> Selection Pane you will get the name of the selection. In this case, your names are Textbox 1, TextBox2 ... I suggest in the future you rename these to something more meaningful.

I converted your data to an Excel Table mainly because Excel tables know how many rows they have. It makes coding a bit easier. I also built a "map" that tells excel where to go in the presentation to get the data you want. I had to use an exception called (Blank) because Who Are You is a title for the Customers rather than something that contains information.

The code goes to the indicated slide, finds the object on the slide and puts it in the appropriate column, advancing one column for each item found.

Use the control panel to fill in the path to the powerpoint slide and the slide name (recommend copy and paste for this.). I didn't do any error proofing.

Originally Posted by djarnot

Excited to run this macro. I'm getting this error and appreciate any advise:
sh.Cells(NextRow, ColNum) = sld.Shapes(cl.Offset(0, 2)).TextFrame.TextRange.Text

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread