View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
oldyork90 oldyork90 is offline
external usenet poster
 
Posts: 20
Default application.version ... is a application.servicepack? vba

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?