Hi,

I am writing a C# application (.NET 3.5) to perform the following:

1. Create a number of worksheets in an Excel 2007 workbook, each worksheet containing charts and associated text. The charts are created using the ChartWizard of the object model.
2. Copy the charts and associated text as images and paste them on slides in a PowerPoint 2007 template

I am attempting to do this via automation. The problem I am encountering is as follows:

1. On a single worksheet, I have four charts, each with associated text (in the cells around the chart objects). I need to copy each chart, with its associated text, and paste each into a separate PowerPoint slide.
2. I define a "Range" object to return the area encompassing the chart and its associated text. e.g. Worksheet.get_Range("A1", "N20")
3. I then use the Range.CopyPicture() method to copy the contents of the range to the clipboard.
4. Finally, I use the Slide.Shapes.Paste() method to paste the picture from the clipboard to a PowerPoint slide.

This only works for the first of the four charts (or ranges). That is, only the first chart is copied along with its text and pasted as is on the slide. For the remaining three charts, only the corresponding text is pasted on the slide; the charts themselves are missing.

Could someone please help me with this?

Thanks a lot.