7/23/2010

Excel to PowerPoint


I developed a VBA application in Excel that creates a powerpoint presentation of nicely formatted slides from the rows in a spreadsheet and released it into public domain. Using powerpoint you can design the layout of each of the pages that will represent a single record adding lines, textboxes, graphics or any other element you can possibly incorporate in PowerPoint. The link to your data is made by referencing the title of the column in the spreadsheet. So, for example, if you have a textbox in your powerpoint template that looks like this:

This product require {Req Prod}

Then the application expects one of the columns in your spreadsheet is titled "Req Prod" and the value in that column will replace the placeholder string {Req Prod} when you run the program. This is very similar to how Word does a mailmerge.

Cool feature alert: you can even include a screenshot for each record!

A sample dataset and template are included.

Click the download link to get this app for free!

4 comments:

Anonymous said...

Thanks for sharing this link, but unfortunately it seems to be offline... Does anybody have a mirror or another source? Please reply to my post if you do!

I would appreciate if a staff member here at tiran.blogspot.com could post it.

Thanks,
Peter

Tiran said...

Peter,

The link works for me. Here is the direct link:

http://sourceforge.net/projects/excel2powerpoin/

Let me know if you can't get it to work. You can go to SourceForge directly and search for Excel2PowerPoint

sanswierd@googlegroups.com said...

Hi Tiran,

do you plan an update on XLSX and 2010 ?

Cheers
Axel

Anonymous said...

Very nice! Is there a chance to export data to powerpoint tables as well?