Q Filtering Windows operating system

This forum is great. I am so humbled.

I want to test the user's machine for the presence of a Windows version that Microsoft still supports (> Windows ME?).

I could do this with Application.Operating System if I knew all of the possible return values..but I don't.

Is there another way, or where can I find a list of possible return values?

Thanks.

Hello Ern2ern,
This list should help...

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Hello Ern2ern,

This macro will provide you with the basic operating system information. For Vista and the Longhorn Server, more API calls are needed to refine the answer. If you need this, let know. Load this code into a Standard VBA Module. The return value of the function is the OS version.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Hello Ernie,

That requires a few more tricks . Before I start writing code for to do that, tell me more about what you are looking for in this system. This will impact on what calls will need to included in the code.

Thanks,
Leith Ross

Hi Leith,

Here is the download: http://www.e-linq.com/Examples/TestExcel.zip

Just open TestExcel1.xls and run the test. It's obviously a work in process but you will get the context of what I am going.

Unlock the VB project with the number 0.

It does not yet include Test 4, which will be a test to see if Import External Data is installed. It also needs actions and instructions for failed tests...here is where I think it would be much cleaner if, rather than show a bunch of directions, the user is prompted to insert his Office disk when Add-ins and/or Import External Data are not installed.

The test will be downloaded from an "Installment Preliminaries" web page when user selects 'Download' to download my product. See my stuff at http://e-linq.com/New_ElinQ/index.php.

Through the TICommunicator2.dll, pass or fail will be sent to my database with reasons and the test files will close. For the user to continue with the download, he must pass the test.

I think now I have an adequate solution, using a formula with what you gave me, concerning the OS and Excel version.

I REALLY appreciate your interest and help!

-Ernie

Hello Ernie,


The TIComunnicator.dll handles your FTP configuration and email setup routines. Nice presentation on the workbook. Seems like it could run the checks a little faster though.

Sincerely,
Leith Ross