The copy as picture (as seen on screen) function in excel 2007 seems to work
for charts if doing it directly from Excel to other application. But if you
try to code it in VBA, more often than not a chart or two disappears and does
not copy to the designated application (e.g. Word). This is annoying. It
works when copying as picture directly from Excel to Word. But once you try
to code it, it is very sporadic. More often than not, eliminated a chart when
pasting?????? Is there something additional that needs to be used in the code?
Usually if I highlight the chart I want to copy via code, it will end up
working. But if I open the file and try to run the macro/code directly, then
all kinds of charts disappear???
I can't seem to find any other problems of this nature out on the web?? It
worked fine for me in 2003, but 2007, the chart object is hit or miss when
copying as picture.
Thank you
Ken