Hi

Im currently making a template to generate a report in PPT. I have a PPT-template including charts and text. I have made a standardized excelsheet with data, and a VBA-code to select the right workbook with the new data, so my problem is to write a code which updates the chartdata in my PPT-template using the open workbooks data.

I have tried to find something similar, but haven't found it yet.

Hopeing for some help

Cheers, Hasse

On Monday, August 30, 2010 3:29 AM vicky wrote:

how to update data in Powerpoint 2007 charts in vba . In 2003 ,
charts were updated in datasheet but in 2007 there is no datasheet
property .
The data needs to be updated from excel file.


Submitted via EggHeadCafe - Software Developer Portal of Choice
SharePoint WorkFlow Basics
http://www.eggheadcafe.com/tutorials...ow-basics.aspx