application.version ... is a application.servicepack? vba

[oldyork90]

I would like to insure a workbook user is using the proper version
with service pack X

I have the first one... application.version. Is there a way to
collect the other?

Thank you

 

[James Ravenswood]

I would like to insure a workbook user is using the proper version
with service pack X

I have the first one... application.version.  Is there a way to
collect the other?

Thank you

From the Build, you can determine the service pack:

Sub whichPack()
MsgBox Application.Version
MsgBox Application.Build
End Sub

 

[oldyork90]

From the Build, you can determine the service pack:

Sub whichPack()
MsgBox Application.Version
MsgBox Application.Build
End Sub

Thank you. Any one have a link to mappings?, build numbers to sp?

 

[Jim Cone]

Things may be a little complicated though - an excerpt from http://support.microsoft.com/kb/821549
....

"You may apply a hotfix or a public update that contains fixes that are provided in the latest
service pack and that updates the Mso.dll file.
In this case, the version of the Mso.dll file that is displayed in the About Microsoft Program name
dialog box adds the letters "SP" and the number of the service pack level.
This occurs even if that service pack is not installed."

(it's great to be king)
'---
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(Formats & Styles: lists/removes unused styles & number formats - in the free folder)




"oldyork90" <[email protected]>
wrote in message

From the Build, you can determine the service pack:

Sub whichPack()
MsgBox Application.Version
MsgBox Application.Build
End Sub

Thank you. Any one have a link to mappings?, build numbers to sp?