How to auto-generate whole Powerpoint presentations from a set of data?

[olibot2000]

Hi. I am looking in to the possibility of more or less generating a whole presentation from a set of data. I will give an example of how I want it all to work: Example Respondents answer and submit forms they've answered (the questions in these forms might vary slightly, some forms will not have all the questions etc). When everyone has submitted their answers then it should be possible to generate a PowerPoint based on these results. I have looked in to Excel, more specifically VBA, but this only seems to be able to update values,

[Petri]

Hi,

You can definitely use VBA to for fully manipulating data both in Excel and PowerPoint. I would assume you could also control PowerPoint data model from Excel VBA, or the other way around, the similar way you can use both of these apps from an external VB.NET application. That will require some programming though.

Or you could use some intermediate format for the data - thinking saving your Excel data as XML or CSV files and then reading that in (and visualizing) through a PowerPoint VBA macro.