How do I determine OS (98 or XP)?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

WDR - 20 Jan 2006 04:19 GMT

Using VBA...
1) How do I determine which operation system (98 or XP) is running on he
computer?
2) For the XP op sys, how do I determine which user is logged into the
computer?

I am using Excel 2000.

Thanks in Advance,
-Warren

Reply to this Message

Gary Keramidas - 20 Jan 2006 04:25 GMT

you can try these

Sub test()
Range("a1") = Environ("os")
Range("a2") = Environ("UserName")
End Sub

Signature

Gary

> Using VBA...
> 1) How do I determine which operation system (98 or XP) is running on he
[quoted text clipped - 6 lines]
> Thanks in Advance,
> -Warren

Reply to this Message

N10 - 20 Jan 2006 09:39 GMT

You could add

Range("a3") = Application.OperatingSystem

> you can try these
>
[quoted text clipped - 13 lines]
>> Thanks in Advance,
>> -Warren

Reply to this Message