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

  • Thread starter Thread starter oldyork90
  • Start date Start date
O

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
 
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
Click to expand...

From the Build, you can determine the service pack:

Sub whichPack()
MsgBox Application.Version
MsgBox Application.Build
End Sub
 
From the Build, you can determine the service pack:

Sub whichPack()
MsgBox Application.Version
MsgBox Application.Build
End Sub
Click to expand...

Thank you. Any one have a link to mappings?, build numbers to sp?
 
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
Click to expand...

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