Select the product you need help with
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 2007Article ID: 948683 - View products that this article applies to. SYMPTOMSYou 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. CAUSEIn 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).
RESOLUTIONTo 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
(http://support.microsoft.com/kb/953195/
)
Description of the 2007 Microsoft
Office Suite Service Pack 2 and Microsoft Office Language Pack 2007
Service Pack 2
WORKAROUNDTo 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. REFERENCESFor 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
(http://blogs.msdn.com/officedevdocs/archive/2008/10/30/office-chart-object-model-in-powerpoint-and-word.aspx)
STATUSThis change to Microsoft Office PowerPoint 2007
and Word 2007 is a known limitation.
PropertiesArticle ID: 948683 - Last Review: April 28, 2009 - Revision: 2.0
| Article Translations |
Back to the top
