Link to home
Start Free TrialLog in
Avatar of Member_2_7966563
Member_2_7966563

asked on

Extract Powerpoint Textboxes into Excel

I have a powerpoint deck with 50 slides. All slides have the same template, and consists of textboxes containing various pieces of information, like a form.

How can I extract all that information into an Excel spreadsheet, one row representing one slide, and one column representing one text box?
Avatar of Misha
Misha
Flag of Russian Federation image

May be this can help you?

Open the embedded info in Excel and save it to a new file:

    Rightclick the chart or worksheet data in PowerPoint
    Choose Chart Object, Open from the pop-up menu. Excel opens with the content loaded.
    Choose File, Save Copy As ...
    Give the new filel a name and save.
    Close Excel.

Or you want to create VBA-macros to do this operation?
ASKER CERTIFIED SOLUTION
Avatar of Jamie Garroch (MVP)
Jamie Garroch (MVP)
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Member_2_7966563
Member_2_7966563

ASKER

Does this VBA go into the Powerpoint or into the Excel file? In what sequence will this routine extract the shapes into Excel? In the order the shapes were created? Will it extract the shapes in the same order in each slide?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial