Extract "System Information" (dxdiag) using VBA

Hello guys,

I've searched on the entire Internet about the possibility of extracting the system information regarding the Operating System , Processor and Memory . I've found a vba code that extracts data like System model, and BIOS version but i don't need them.


The purpose of this code is to see how long a script will run some specific PC's and gather them in one email (i can do this), but i dont know how to extract them from the registry or anyplace.

Thanks,
Alex

No idea what you mean by "to see how long a script will run" but to run dxdiag passing the output to a file use...

Please Login or Register  to view this content.

You may have to change some directory paths depending on your local environment and be aware DXDIAG will be shelled but the code will continue immediately. It will take a few seconds for the output file to appear in the destination directory.

sweep , i have tried that WMI method but the RAM memory cannot be correctly extracted.
cytop, i've tried your idea but on some pc's the have only 1 partition and no access to partition C (the only one available)

The code is generic - I have no idea of your local environment so something that works on my machine was posted.

I guess you need to find where the System directory (or whatever passes as the System directory on your machine) is - you can do that a couple of ways including using the GetSpecialFolder() API function. Plenty of examples all over the place.

If you do get it to work, you can use '/x' as the switch rather than '/t' to create an XML output file. Might make it easier to extract he various bits of info you need.

cytop, i will try to use the idea provided by sweep because our system directories varies on every PC. Thanks