View Full Version : VBA for pasting excel chart in powerpoint

05-28-2010, 02:34 AM

Im looking for a macro that would take a couple of charts that I have in an excel file and paste as metafile in an existing powerpoint on different slides.

For example, the excelfile have 14 different worksheets and each worksheet have one chart (but i dont want to import all of them only some).

My powerpoint file have 9 slides (first and last slide should not contain any chart, since they are just welcoming and ending slides.)

I want the makro to take the chart from worksheet 3 and put in slide 2, and from worksheet 4 into slide nr 3 and so on. It would be great not to use and if function here so that i could chose which worksheet to import the chart from.

Thanks in advance!