Home |
Search |
Today's Posts |
#9
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
It is always better to use the Set variable name instead of its location in
the list (which could be different between different computers). For the operating system, that would be 'OS' as in... mysystem = Environ("OS") However, this only return Windows_NT whereas the Application.OperatingSystem statement mentioned elsewhere in this thread returns this.. Windows (32-bit) NT 6.00 which contains a little extra information. By the way, if you ever want to see the various variable (names, for use in the Environ statement, and settings), bring up a Command Prompt window (found in All Programs, Accessories I think), type SET and hit the Enter key. Rick "Mike H" wrote in message ... Hi, This reports it correctly on mine but not tested on other systems mysystem = Environ(13) Mike "avi" wrote: Hello, Is there a simple way to know programatically if the user's computer runs Vista or XP? Thanks a lot Avi |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hide all windows while macro is running | Excel Programming | |||
i have two windows xp running on my pc and seem to con flict with | Excel Discussion (Misc queries) | |||
Detecting if workbook running in IE or in Excel | Excel Programming | |||
Running windows command from a VB code | Excel Programming | |||
running windows system commands in VBA | Excel Programming |