PPT2007 Charts and VBA

I remember coming across a problem with charts in a VBA program I have
written when the customer upgraded to 2007. Looking into the matter, I
came across the listing at PPTTools which mentions that 2007 charts
are not exposed to VBA: http://www.pptfaq.com/FAQ00889.htm

At the time, I believe a coworker had checked the 'Convert' when
editing a chart, and it no longer worked with the program I had
written. Now the same charts seem to be working again when they are
converted, or even created as brand new charts in 2007 with the same
code. Is this something that Microsoft fixed at some point? If so,
does anyone know what version was the fix applied, and can I test for
the service pack version in VBA to make sure my client has the proper
upgrade when running the code?

I believe I found my answer to the charts: http://support.microsoft.com/kb/948683

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.

Is there a way to determine with VBA if this service pack has been
installed? The only property I can see that I think might be it is the
application.build property. On my machine, I get '6425' for this value.

If it's any help I get 6514 on PP2007 SP2 and 4535 on PP2010 beta

Mark wrote:
I believe I found my answer to the charts: http://support.microsoft.com/kb/948683

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.

Is there a way to determine with VBA if this service pack has been
installed? The only property I can see that I think might be it is the
application.build property. On my machine, I get '6425' for this value.

On Mar 4, 9:54*am, James jahbur-at-yahoo.co.uk wrote:
If it's any help I get 6514 on PP2007 SP2 and 4535 on PP2010 beta



Mark wrote:
I believe I found my answer to the charts:http://support.microsoft.com/kb/948683

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.

Is there a way to determine with VBA if this service pack has been
installed? The only property I can see that I think might be it is the
application.build property. On my machine, I get '6425' for this value.- Hide quoted text -

- Show quoted text -

Thanks for the response. Don't know how helpful it is to me until I
can determine if a specific number or number range specifies SPX. I
checked several computers in the office, and I'm getting so far 2
different numbers; yours is a 3rd value.

In the PowerPoint options I checked and got 12.0.6425.1000 on 2
machines, and 12.0.6504.5000 on 2 other machines. The first set of 4
digits after the version (12.0) correlates with the 'Build' number for
the application. Don't know what the last 4 digits means.

I'll have to keep looking online hoping I can find an answer, or hope
that someone knowledgeable responds here.

Thanks again