View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone[_2_] Jim Cone[_2_] is offline
external usenet poster
 
Posts: 1,549
Default application.version ... is a application.servicepack? vba

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?