Excel data into PowerPoint slides
Posted
by
nqw1
on Super User
See other posts from Super User
or by nqw1
Published on 2011-08-15T13:05:19Z
Indexed on
2012/09/21
3:41 UTC
Read the original article
Hit count: 493
I have already found some helpful sites but I'm still unable to do what I want. My Excel file contains few columns and multiple rows. All the data from one row would be in one slide but data from different cells in that one row should go to a specific elements in PP slide. At first, is it possible to export data from an Excel cell into a specific text box in PP? For example, I would like to have all data from the first column of each row go to a Text box 1. Let's say I have 100 rows so I would have 100 slides and each slide would have Text bow 1 with correct data. Text box of slide 66 would have data from the first column of row 66. Then all data from the second column of each row would go to a text bow 2 and so on.
I tried to do some macros with bad success. I also tried to use Word outlines and export them into PP (New slide -> Slides from Outline) but there seems to be a bug since I got 250 pages of gibberish. I had only two paragraphs and both had one word. First paragraph used Heading 1 style and second paragraph used Normal style.
Sites what I have found, use VB and/or some other programming language to create slides from Excel sheets. I have tried to add those VB codes into my macros but none of them hasn't worked so far. Probably I just don't know how to use them correctly :) Here's some helpful sites:
VBA: Create PowerPoint Slide for Each Row in Excel Workbook
Creating a Presentation Report Based on Data
I use Office 2011 on Mac. Any help would be appreciated!
© Super User or respective owner