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"
wrote in message
...
On Mar 29, 12:37 pm, James Ravenswood
wrote:
On Mar 29, 12:59 pm, oldyork90 wrote:
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
Thank you. Any one have a link to mappings?, build numbers to sp?