PPT2007 Charts and VBA

[Mark]

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?

 

[Mark]

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.

 

[James]

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

 

[Mark]

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






- 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

 

[Mark]

I've been told by someone at MS that the build numbers aren't entirely
reliable as indicators of SP level but as far as I (and they) know, it's the
best we've got.

6412 is the first build number that corresponds to SP2, to the best of my
knowledge.  







==============================
PPT Frequently Asked Questionshttp://www.pptfaq.com/

PPTools add-ins for PowerPointhttp://www.pptools.com/- Hide quoted text -

- Show quoted text -

Thanks for the info, Steve. I have since come across this page which
helps to determine the Build numbers for the different SP versions,
although it doesn't give a definite 'range' to determine which one is
installed. It also doesn't explain why I am getting different numbers
across the computers installed at my office.

http://support.microsoft.com/kb/928116

I also found another site referring to the meaning of the build
number, but unfortunately that only seems to apply to the original
version, not the SP versions.

http://blogs.msdn.com/jensenh/archive/2005/11/11/491779.aspx

Based on the table on the first page I linked, I will assume that
anything under 6200 is Original version, anything under 6400 is SP1,
and everything else is SP2, and *hope* that this doesn't give me any
problems.