Using VBA to import source data...

[Guest]

Can you use VBA in powerpoint to import or retrieve data from an Excel
workbook or worksheet to create a chart? I have had no luck so far finding
any info on how to do this. We have 15 slides with up to 9 charts per slide.
Needless to say it's a bit tedious creating these manually.

We are using 2003 version.

I am assuming that each chart is an object in a slide and each slide is an
object in a presentation. I really hope this is possible. Any help would be
greatly appreciated.

Thanks,
Chris

 

[Steve Rindsberg]

Can you use VBA in powerpoint to import or retrieve data from an Excel
workbook or worksheet to create a chart? I have had no luck so far finding
any info on how to do this.

It can be done but it's not a starter project if you're just learning VBA and
PowerPoint.

Try http://www.pptfaq.com and search on Excel for example.

We have 15 slides with up to 9 charts per slide.
Needless to say it's a bit tedious creating these manually.

You could also create the charts once in Excel and link them to PPT.
You'd then be able to change the data in Excel, save the workbook and PPT would
update the presentation automatically when you opened it the next time.

In other words, there may not be any need for VBA at all.