View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
David Coleman[_3_] David Coleman[_3_] is offline
external usenet poster
 
Posts: 7
Default System Root directory

Hi Jack

Environ("windir") will return the windows directory

and

Application.OperatingSystem will return the version of windows

eg msgbox(environ("windir"))
or msgbox(application.operatingsystem)

HTH

David


"Jack" wrote in message
...
Any ideas on how to determine what version of windows is
being run, and what the system root directory is?

e.g. c:\winnt OR c:\windows etc.

Thanks

Jack