PDA

View Full Version : Excel to powerpoint template



pkantilal
02-18-2015, 12:56 PM
Hello


Im an intern at a ecommerce company, and every day i have have to produce 80 Powerpoints from data that i recieve in an excel file.


So i have an powerpoint template, where i need to change 10 fields, fields that i have to pull from the excel file.


Each line containing 10 columns of data that i put in the powerpoint presentation and save it, one by one in a prticular name, (ps i


have to save it, as PDF too).


ive seen some examples in the internet, but couldnt find nothing from VBA examples that could help me.


Is there a way that i could save 4 hours of my time?


Thank you for any help.

John Wilson
02-19-2015, 02:54 AM
We have a commercial "Mail merge for PPT" Add In. Not free but cheap! It needs a csv file which you could make in Excel. If it doesn't do what you need simply ask for a refund within 30 days of purchase!

http://www.pptalchemy.co.uk/Simple_merge.html

Bob Phillips
02-19-2015, 04:20 AM
If you post an example Excel workbook, the Powerpoint template, and possibly an example Powerpoint result, I am sure we could knock something up for you.