View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
James Ravenswood James Ravenswood is offline
external usenet poster
 
Posts: 143
Default application.version ... is a application.servicepack? vba

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