VBA WMI Explorer

Over the years, I’ve posted all sorts of code samples using WMI to get all sort of information from a PC, things like:

MS Access - VBA - Kill a Process
Every once in a while, programs do not shutdown properly and thus cause headaches. So it can become necessary to terminate the process.
VBA - Get Processor Id
I was helping someone out in a forum that was trying to determine the computer’s Processor Id to use it as part of a registration system. Once again WMI automation can enable us to get this information. Below was the function I put together.
Getting The Hard Drive Serial Number With VBA
I was trying to help in the following Answers forum thread In which Wahedi is inquirying about retrieving the HDD serial number. I knew I had such code stored away because I had done this on a personal project many years ago.  I also knew I had previously provided code to retrieve the BIOS serial…

Continue reading →

and many, many more!

For fun, I put together a more generalized, what I’ve deemed ‘WMI Explorer’ code.  Basically, you pick the WMI NameSpace, and Class and then you can view all the associated properties.  I’ve even added the ability to export  the results to Excel.

It will even return the description of a Class (when selected) as well as the description of each individual property (when selected).  This can help reduce the time sifting through documentation.

Access WMI Explorer Form

As I said, this was just for fun, personal learning, but still thought it might be of interest for some.

Disclaimer/Notes:

If you do not have Microsoft Access, simply download and install the freely available runtime version (this permits running MS Access databases, but not modifying their design):

Microsoft Access 2010 Runtime
Microsoft Access 2013 Runtime
Microsoft Access 2016 Runtime
Microsoft 365 Access Runtime

All code samples, download samples, links, ... on this site are provided 'AS IS'.

In no event will Devhut.net or CARDA Consultants Inc. be liable to the client/end-user or any third party for any damages, including any lost profits, lost savings or other incidental, consequential or special damages arising out of the operation of or inability to operate the software which CARDA Consultants Inc. has provided, even if CARDA Consultants Inc. has been advised of the possibility of such damages.

Download a Demo Database

Feel free to download a 100% unlocked demo copy by using the link provided below:

Download “WMI Explorer Demo” WMI_Demo_V1.000.zip – Downloaded 5266 times – 62.32 KB

Version History

Version Date Changes
V1.000 2022-02-27 Initial Release

Other References on the Subject

Windows Management Instrumentation - Win32 apps
Windows Management Instrumentation (WMI) is the infrastructure for management data and operations on Windows-based operating systems.