Results 1 to 13 of 13
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts

    Which version of 2003 (2003)

    A VB question, but Excel related: I'd like to know which version of Excel 2003 a user has (Standard or Professional). I believe the version numbers are the same, and I can't seem to find a property that distinguishes them. Can anyone suggest one?

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Which version of 2003 (2003)

    Kevin

    have you tried:

    Sub myVersion()
    MsgBox Val(Application.Build)
    End Sub

    <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Jerry

  3. #3
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Which version of 2003 (2003)

    I don't have XL 03 here, so I cannot try it, but if Jezza's approach doesn't work, you may be able to try to access something like xmlMap that is defined in Pro but not in Standard and trap the error. If no one comes up with a solution, I'll have XL 03 in the morning.
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts

    Re: Which version of 2003 (2003)

    I believe that is just a build number, and to the best of my knowledge it may be the same between professional and standard. But, I'm running Professional here and cannot try it on a Standard until tomorrow. Can't this number change based upon patches that are applied? (I'm not 100% sure about this last point though, but suspect.)

  5. #5
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Which version of 2003 (2003)

    I don't know of any VBA property that would give you this information (in fact, I couldn't say for sure there is any difference between Excel in Pro and in Standard) - can I ask what the underlying reason for trying to determine this is?
    Regards,
    Rory

    Microsoft MVP - Excel

  6. #6
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts

    Re: Which version of 2003 (2003)

    Maybe it's this:
    What it could be is this:
    Application.ProductCode

    i have professional and it returns :
    {90110409-6000-11D3-8CFE-0150048383C9}

    According to this article - http://support.microsoft.com/default.aspx?...kb;en-us;302663
    the guid can be parsed apart as follows

    Characters Definition Used Hex values
    ------------------------------------------------------------------
    W Release type 0-9, A-F
    X Edition type 0-2
    YY SKU of the product 10-35
    ZZZZ Language identifier of the product any required


    and if we use the same sku as office xp then we are good to go:

    Value SKU
    --------------------------------------------------------------------
    11 Microsoft Office XP Professional
    12 Microsoft Office XP Standard
    13 Microsoft Office XP Small Business
    14 Microsoft Office XP Web Server
    15 Microsoft Access 2002
    16 Microsoft Excel 2002

    So from the product code i gave before:
    {90110409-6000-11D3-8CFE-0150048383C9}
    I can tell the following:
    9 - RTM build
    0 - Enterprise
    11- Microsoft Office XP Professional (yeah i know it says xp...but it also says professional)
    0409 - English

    Rory...it was or is my understanding that some things are disabled in Standard that aren't in Professional. My company is trying to interface with SmartDocument and apparently that's disabled in the Standard version.

  7. #7
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Which version of 2003 (2003)

    Hi there, this will give you the build of the excel installed.

    I have just written this which will give you version and build:

    Sub myVersion()
    MsgBox "Version " & Application.Version & vbCrLf & "Build " & Val(Application.Build)
    End Sub

    http://support.microsoft.com/default.aspx?scid=kb;[LN];291331

    (sorry Lounge cannot parse this link so you will have to copy and paste)

    You may have to check for packs, buut I have a feeling I may have sent you up a blind alley as I cannot determine if there is a difference....my apologies if I have.
    Jerry

  8. #8
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Which version of 2003 (2003)

    ProductCode, great find! The GUID for 2003 has been expanded, see http://support.microsoft.com/kb/832672/
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  9. #9
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts

    Re: Which version of 2003 (2003)

    Thanks, Sammy...I just found that one also...phew.

  10. #10
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Which version of 2003 (2003)

    Nice find Kevin
    Jerry

  11. #11
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Which version of 2003 (2003)

    Thanks for the info - this appears to be a new thing with 2003 as far as I can tell, so it's good to be aware of before I start thinking about upgrading!
    Regards,
    Rory

    Microsoft MVP - Excel

  12. #12
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Ankeny, Iowa, USA
    Posts
    298
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Which version of 2003 (2003)

    Differences between Professional and other versions can be found here http://www.microsoft.com/office/editions/p...ctionality.mspx

  13. #13
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Which version of 2003 (2003)

    Thanks. Now that I have thought about it, I don't think it will affect me as you have to buy Pro (or better) to get Access anyway and the other factors are immaterial now that I am no longer The Omnipotent Ruler of IT Services! <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •