I'd like to be able to run a bit of code on all of my user's workstations to
determine if SP2 is installed. I'm pretty much open to any method that works.

TIA

Doug

Application.Build

This is the Build's I have for my 2007 SP1 & SP2 respectively
6331, 6524

My guess is if it's say 6500+ you can be pretty sure it's SP2 (in 2007 of
course), but I'll leave it to you to research if that is indeed the case.
Maybe you might post back your findings!

Regards,
Peter T



"Doug_F" wrote in message
...
I'd like to be able to run a bit of code on all of my user's workstations
to
determine if SP2 is installed. I'm pretty much open to any method that
works.

TIA

Doug

Peter,

Thanks. Off to write some code and trap some data.

Doug

"Peter T" wrote:

Application.Build

This is the Build's I have for my 2007 SP1 & SP2 respectively
6331, 6524

My guess is if it's say 6500+ you can be pretty sure it's SP2 (in 2007 of
course), but I'll leave it to you to research if that is indeed the case.
Maybe you might post back your findings!

Regards,
Peter T



"Doug_F" wrote in message
...
I'd like to be able to run a bit of code on all of my user's workstations
to
determine if SP2 is installed. I'm pretty much open to any method that
works.

TIA

Doug


.

I have a similar need, and I found this thread (and forum) in my
search. On the computers I have checked in my office, I am getting 2
different numbers for SP2

12.0.6425.1000 SP2
12.0.6504.5000 SP2

The first set of 4 digits after the version number (12.0) correlates to
the Build number; don't know what the last set of 4 digits signifies.

Has anyone resolved how to determine which numbers (or number range)
distinguishes SP1 from SP2? Since I'm getting 6425, it would appear that
6500 is not the lower limit for SP2 as has been suggested here.


Doug_F;645959 Wrote:

Peter,

Thanks. Off to write some code and trap some data.

Doug

"Peter T" wrote:

Application.Build

This is the Build's I have for my 2007 SP1 & SP2 respectively
6331, 6524

My guess is if it's say 6500+ you can be pretty sure it's SP2 (in
2007 of
course), but I'll leave it to you to research if that is indeed the
case.
Maybe you might post back your findings!

Regards,
Peter T



"Doug_F" wrote in message
...
I'd like to be able to run a bit of code on all of my user's
workstations
to
determine if SP2 is installed. I'm pretty much open to any method
that
works.

TIA

Doug


.



--
Cosmo
------------------------------------------------------------------------
Cosmo's Profile: 1576
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=179767

Microsoft Office Help

Interesting observation. I agree the first set of 4 digits correlates to the
Build number.

FWIW I hadn't suggested 6500 was the lower limit, rather as a guess above
that probably confirms SP2, not quite the same thing. However I am now
starting to wonder if the build number even relates to the SP at all, maybe
it doesn't!

Regards,
Peter T

"Cosmo" wrote in message
...

I have a similar need, and I found this thread (and forum) in my
search. On the computers I have checked in my office, I am getting 2
different numbers for SP2

12.0.6425.1000 SP2
12.0.6504.5000 SP2

The first set of 4 digits after the version number (12.0) correlates to
the Build number; don't know what the last set of 4 digits signifies.

Has anyone resolved how to determine which numbers (or number range)
distinguishes SP1 from SP2? Since I'm getting 6425, it would appear that
6500 is not the lower limit for SP2 as has been suggested here.


Doug_F;645959 Wrote:

Peter,

Thanks. Off to write some code and trap some data.

Doug

"Peter T" wrote:

Application.Build

This is the Build's I have for my 2007 SP1 & SP2 respectively
6331, 6524

My guess is if it's say 6500+ you can be pretty sure it's SP2 (in
2007 of
course), but I'll leave it to you to research if that is indeed the
case.
Maybe you might post back your findings!

Regards,
Peter T



"Doug_F" wrote in message
...
I'd like to be able to run a bit of code on all of my user's
workstations
to
determine if SP2 is installed. I'm pretty much open to any method
that
works.

TIA

Doug


.



--
Cosmo
------------------------------------------------------------------------
Cosmo's Profile: 1576
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=179767

Microsoft Office Help

Sorry, didn't mean to imply that the suggestion was based on more than
a guess, should have said something more along the lines of 'as has been
suggested might be the case'

A little more investigating in my office showed a few other details:
I've been checking the Resources panel in PowerPoint and I have found a
few machines that show different results:

My computer and another I checked shows both sets of numbers the same:
Microsoft Office PowerPoint 2007 (12.0.6425.1000) SP2 MSO
(12.0.6425.1000)
These numbers are the same in Excel and Word as well.

On a few computers, the two sets of numbers are different:
Microsoft Office PowerPoint 2007 (12.0.6504.5000) SP2 MSO
(12.0.6425.1000)
Microsoft Office Excel 2007 (12.0.6514.5000) SP2 MSO (12.0.6425.1000)
The number which corresponds with the 'Application.Build' is the first
set of 4 digits in the first group of numbers (before the 'SP2'), and is
different for each Office application.

I wish I knew if this number has any correlation to the SP number; I
feel like I'm making some slight progress, but can't tell if I'm
actually getting anywhere. And I haven't found anywhere that explains
what these numbers mean, and why they are not consistent across our
systems.

Peter T;661204 Wrote:

Interesting observation. I agree the first set of 4 digits correlates
to the
Build number.

FWIW I hadn't suggested 6500 was the lower limit, rather as a guess
above
that probably confirms SP2, not quite the same thing. However I am now
starting to wonder if the build number even relates to the SP at all,
maybe
it doesn't!

Regards,
Peter T

"Cosmo" wrote in message
...

I have a similar need, and I found this thread (and forum) in my
search. On the computers I have checked in my office, I am getting 2
different numbers for SP2

12.0.6425.1000 SP2
12.0.6504.5000 SP2

The first set of 4 digits after the version number (12.0) correlates
to
the Build number; don't know what the last set of 4 digits
signifies.

Has anyone resolved how to determine which numbers (or number range)
distinguishes SP1 from SP2? Since I'm getting 6425, it would appear
that
6500 is not the lower limit for SP2 as has been suggested here.


Doug_F;645959 Wrote:

Peter,

Thanks. Off to write some code and trap some data.

Doug

"Peter T" wrote:

Application.Build

This is the Build's I have for my 2007 SP1 & SP2 respectively
6331, 6524

My guess is if it's say 6500+ you can be pretty sure it's SP2 (in
2007 of
course), but I'll leave it to you to research if that is indeed
the
case.
Maybe you might post back your findings!

Regards,
Peter T



"Doug_F" wrote in message
...
I'd like to be able to run a bit of code on all of my user's
workstations
to
determine if SP2 is installed. I'm pretty much open to any
method
that
works.

TIA

Doug


.



--
Cosmo

------------------------------------------------------------------------
Cosmo's Profile: 1576
View this thread:
'Any way to determine Service Pack level on an Excel install - The
Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...d.php?t=179767)

'Microsoft Office Help' ("http://www.thecodecage.com")



--
Cosmo
------------------------------------------------------------------------
Cosmo's Profile: 1576
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=179767

Microsoft Office Help