Results 1 to 5 of 5
  1. #1
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Finding a Window (Excel 97 and >)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Loungers


    I need a Select Statement to use with Application.OperatingSystem to detect what Windows is running, like Windows 95, or Windows 98, or 98SE, or XP Home, or XP Pro or maybe NT 4.0?

    I know that the version is the last bit of what the string will hold, and not knowing any numbers other than 5.00 = 2000 Pro, what else can I do to find this info?

    Thanks

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Finding a Window (Excel 97 and >)

    If you're simply asking how Windows versions are numbered: <UL><LI>There is an MSKB list for the 9x versions. <LI>NT 4.0 = 4.0.xxx - where xxx is the build number (perhaps in the 1300 region???). <LI>XP is 5.1.xxx. I am not aware of the versioning/build number difference between XP Pro and XP Home. Perhaps other Loungers can chip in.[/list]HTH
    Gre

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Marietta, Georgia, USA
    Posts
    296
    Thanks
    9
    Thanked 4 Times in 4 Posts

    Re: Finding a Window (Excel 97 and >)

    (Edited by HansV to make URL's clickable - see <!help=19>Help 19<!/help>)

    It doesn't look like Application.OperatingSystem will give you the detailed version information you need. For Windows XP Pro, I get this:

    ? Application.OperatingSystem
    Windows (32-bit) NT 5.01

    If you want to detect all the details, you'll need to use some Windows API calls. For a much more complete version see Visual Studio Magazine 05/15/2002 article named "Detect Your Windows version" by Hank Marquis:
    http://www.ftponline.com/vsm/2002_05/magaz.../default_pf.asp

    You can also download the code for the article by going to this page, clicking on "Archive" on the left, then navigating to 2002, and the May issue:
    http://www.ftponline.com/archives/magazines/vsm/
    Rick Groszkiewicz
    Life is too short to drink bad wine (or bad coffee!)

  4. #4
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Finding a Window (Excel 97 and >)

    <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15> Unkamunka

    This MSKB article gave me a lot to work with.

    I'll post the code back here when I know it does a Good Job.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  5. #5
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Finding a Window (Excel 97 and >)

    <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15> Rick

    I should send for a subscription to the Visual Studio Magazine, I think they do have a lot of articles that are neat.

    I'll do that as soon as I... well maybe tomorrow <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Thanks again, it was helpful to read the article.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

Posting Permissions

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