Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
... the system root directory is?
Would any ideas here help? Sub Demo() Const WindowsFolder = 0 Const SystemFolder = 1 Const TemporaryFolder = 2 With CreateObject("Scripting.FileSystemObject") Debug.Print .GetSpecialFolder(WindowsFolder) Debug.Print .GetSpecialFolder(SystemFolder) Debug.Print .GetSpecialFolder(TemporaryFolder) End With End Sub -- Dana DeLouis Using Windows XP & Office XP = = = = = = = = = = = = = = = = = "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 |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Jack,
Sub test() MsgBox (Environ("WINDIR") & _ Application.PathSeparator & _ IIf(InStr(1, Application.OperatingSystem, "32"), "System32", "System")) End Sub Rob "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I open an Excel file on XP system, saved on a Vista system | Excel Discussion (Misc queries) | |||
Excel Email Attachment Save As Root Directory | Excel Discussion (Misc queries) | |||
Saving to root directory | Excel Discussion (Misc queries) | |||
global change to document hyperlink root directory | Links and Linking in Excel | |||
Check if directory empty OR no of files in directory. | Excel Programming |