Copy Excel Ranges to PP in Office 2007
Hi!
I have a problem with Range.CopyPicture method in Office 2007. I have used
same kind of code in Office 2000 and Office 2003 and it works fine. the code
copies ranges from Excel to slides in PowerPoint Presentation.
The problem occurrs when there is a graph on the range that is copied.
Usually the Graph is copied to the picture as well. This is the way it should
go, but sometimes everything else is copied but the graph. The code copies
multiple ranges and these ranges can have multiple graphs. Sometimes
everything copies ok, sometimes some graphs are missing.
There is a parameter for the method which specifies the appearance how the
picture should be copied. The default is xlScreen. If i use xlPrinter instead
of xlScreen the code works, but it is slower and if i want to have colors in
the pictures, i have to select color printer as the active printer.
I would like to use the xlScreen setting because this code is used by many
users on different machines and they may not have printers installed. Or if
they have, they may not have color printer installed.
Can anyone help me with this problem?
Best Regards,
Markus
|