API function to return the "System Drive" 2

[Adeybaby]

Hi all

I currently use ENVIRON("SYSTEMDRIVE&quot to return the system drive from the system environment variable, usually this is "C:".

I understand that environment variables are not the best way to get this information, and I have used API calls to return all of the other folders I need (windows folder, progam files etc) but cannot find one for the system drive.

Anybody know if there is one?
Thanks for any help!
Ade

 

[DrJavaJoe]

Adeybaby, welcome to Tek-Tips try using the FileSystemObject.

Dim fso
Set fso = CreateObject("Scripting.FileSystemObject&quot
Const SystemFolder = 1
MsgBox fso.GetSpecialFolder(SystemFolder)

 

[Adeybaby]

Thanks Joe. I can use that and check for the leftmost character for the drive letter.

Thanks for the prompt answer!

Adeybaby

 

[strongm]

MsgBox fso.GetDriveName(fso.GetSpecialFolder(SystemFolder))