View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Programmatically copying charts and cells from Excel into PowerPoi

Tell 'em to upgrade to Excel 2003. I've been dissatisfied with copying and
pasting graphical elements (not just charts) from Excel 2007.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Barb Reinhardt" wrote in message
...
I have a PowerPOint presentation that is popululated from Excel using a
macro. In 2003 it worked fine (well, I wasn't totally happy, but it
saved
users a lot of time). It chooses a selection (including the range
enclosing
the chart + other data that they want to include on the slide) and copies
the
selection to the PowerPoint slide. Anyway, now that I'm testing it in
2007,
I sometimes get half of the graph in the copy. I've tried all
combinations
of CopyPicture in Excel 2007 and none really works very well. What next?
I'm wondering if a permutation of ALT PRINT Screen may work. But that
could
be iffy as well. This tool has got to work or I'll have 100's of unhappy
folks.

Barb Reinhardt