Determining OS from VBA

[Brian]

I have an app in which I am shelling out to FTP to download some files but
killing the FTP session if it times out or otherwise hangs. However, Windows
2000 uses kill, whereas Windows XP uses taskkill. How can I determine the OS
at runtime so that I do not have to manually change my code depending on the
OS version of the station on which it is installed. There are really only
three OS candidates in my environment: Windows 2000 (server or workstation),
Windows 2003 server, and Windows XP Pro.

 

[Douglas J Steele]

http://www.mvps.org/access/api/api0055.htm at "The Access Web" has most of
it. It just hasn't been updated to reflect Windows 2003 Server. However, you
should be able to figure the necessary constants out for yourself (sorry, I
don't have ready access to a Win2003 server at the moement, so I can't get
them for you).

 

[Brian]

Thanks. Yes, I can get the additional constants. This will save some manual
tinkering with VBA during testing & implementation.