Before installing the Office 2007 suite Service Pack 2, you cannot use Microsoft Visual Basic for Application (VBA) to modify a chart that you have inserted in PowerPoint 2007 or Word 2007

Article translations Article translations
Article ID: 948683 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

You cannot use Microsoft Visual Basic for Application (VBA) to modify a chart that you have inserted in Microsoft Office PowerPoint 2007 or Office Word 2007.

Note You can use VBA modify a chart that you insert in earlier versions of PowerPoint.

CAUSE

In Microsoft Office PowerPoint 2007 or in Office Word 2007, the chart object model (OM) is no longer available in Microsoft Visual Basic for Application (VBA).

RESOLUTION

To resolve this issue, install 2007 Office Suite Service Pack 2. After you install 2007 Office Suite Service Pack 2, you can use Microsoft Visual Basic for Application (VBA) to modify a chart that you have inserted in PowerPoint 2007 or Word 2007. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
953195 Description of the 2007 Microsoft Office Suite Service Pack 2 and Microsoft Office Language Pack 2007 Service Pack 2

WORKAROUND

To work around this issue, use VBA in Excel to modify the inserted chart. Then, paste the chart from Excel into PowerPoint 2007 or Word 2007 by using the VBA Automation techniques.

REFERENCES

For more information about Office Chart Object Model in PowerPoint and Word, visit the following Microsoft Web site:
http://blogs.msdn.com/officedevdocs/archive/2008/10/30/office-chart-object-model-in-powerpoint-and-word.aspx

STATUS

This change to Microsoft Office PowerPoint 2007 and Word 2007 is a known limitation.

Properties

Article ID: 948683 - Last Review: April 28, 2009 - Revision: 2.0
APPLIES TO
  • Microsoft Office PowerPoint 2007
Keywords: 
kbexpertiseadvanced kbtshoot kbprb KB948683

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com