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?
How can I extract all that information into an Excel spreadsheet, one row representing one slide, and one column representing one text box?
Microsoft PowerPointMicrosoft ExcelMicrosoft Office
Last Comment
Jamie Garroch (MVP)
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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?