Hi all,
I have set up a template of which I run code to transfer ranges and charts over to the template each week to generate a number of slides.
This usually works perfectly ok.
However now and again it all goes wrong when it comes to the charts.
The code assigns the slide, copies the chart (tried enhanced metafile, just paste and other types), pastes it on the slide and then finds the last shape & alters its position.
However sometimes it alters the position of text box instead of the chart, sometimes it hasn't copied the chart and then sometimes after it keeps copying the same chart instead of picking up the new charts when pasting onto the following slides.
I have tried clearing the copy paste after, I have also used the API to clear the clipboard.
Sometimes it works perfectly, other times it goes wrong.
I have been using this on Excel 2010 & PowerPoint 2003
I tried it on Excel 2007 and it works ok
I have highlighted the area where it goes wrong
Please Login or Register to view this content.
Bookmarks