Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 20
Default application.version ... is a application.servicepack? vba

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
  #2   Report Post  
Posted to microsoft.public.excel.programming
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
  #3   Report Post  
Posted to microsoft.public.excel.programming
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?
  #4   Report Post  
Posted to microsoft.public.excel.programming
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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Application.VBE.Version on Excel XP Jeremy Excel Programming 5 May 30th 05 11:03 AM
Conditional Compilation using Application.Version Stephen Bullen[_4_] Excel Programming 0 November 9th 04 09:48 AM
excel version and servicepack sanjay wankhede Excel Programming 2 September 15th 04 02:01 PM
excel 2002 build version and servicepack information needed sanjay wankhede Excel Programming 3 September 14th 04 01:26 PM
Help in using Application.Version Tom Ogilvy Excel Programming 0 April 1st 04 04:21 AM


All times are GMT +1. The time now is 12:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"