Meerc
06-16-2008, 06:57 AM
Every month I need to create a large report that requires pasting multiple excel charts into multiple slides in PowerPoint. I have an Excel workbook with 25 charts in one worksheet and I need to update an existing presentation with these graphs.
So what I need to do is:
Open an existing presentation and clear the graphs that exist on the slides
Copy the charts in the worksheet one by one and paste them on designated slides in the presentation
Please note:
All the 25 charts will have to be pasted in different slides
It is not the case that chart1 goes to slide1 and chart25 goes to slide25...there is no such order. It is like, chart1 to slide 3, chart2 to slide7, chart3 to slide8 and so on. So, I will need to guide which chart is pasted on which slide.
The new charts will have to be in the same position as the previous charts on the slides.
Most of the slides have one chart only but one slide has two charts.
Can you please tell me how this can be automated using Excel VBA? I really need this urgently so any help is appreciated.Thanks a lot!
So what I need to do is:
Open an existing presentation and clear the graphs that exist on the slides
Copy the charts in the worksheet one by one and paste them on designated slides in the presentation
Please note:
All the 25 charts will have to be pasted in different slides
It is not the case that chart1 goes to slide1 and chart25 goes to slide25...there is no such order. It is like, chart1 to slide 3, chart2 to slide7, chart3 to slide8 and so on. So, I will need to guide which chart is pasted on which slide.
The new charts will have to be in the same position as the previous charts on the slides.
Most of the slides have one chart only but one slide has two charts.
Can you please tell me how this can be automated using Excel VBA? I really need this urgently so any help is appreciated.Thanks a lot!