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.

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

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.


On Tuesday, October 12, 2010 5:33 AM hasse fensman wrote:

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


Submitted via EggHeadCafe - Software Developer Portal of Choice
JustCode Visual Studio Development Add-In by Telerik
http://www.eggheadcafe.com/tutorials...y-telerik.aspx

Hi,

What you'd need is an event procedure within Powerpoint. Don't ask me why,
but for some reason you can't access these in Powerpoint like you would in
Excel or Word. You need to write a class module, referencing the Powerpoint
application. Then you need to assign an object to this class and within
this object, you can access the event procedures. It is too complicated to
explain all this in a simple message, but there is plenty of info on the
internet regarding this. A good explanation can be found on

http://www.vbaexpress.com/kb/getarticle.php?kb_id=327

rgds,
Carl


hasse fensman wrote in
:

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.


On Tuesday, October 12, 2010 5:33 AM hasse fensman wrote:

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


Submitted via EggHeadCafe - Software Developer Portal of Choice
JustCode Visual Studio Development Add-In by Telerik
http://www.eggheadcafe.com/tutorials...6e-48e7-b381-f
cd1938b6775/justcode-visual-studio-development-addin-by-telerik.aspx