Dear All,
such a long time from my last post but hopefully I'm here again to find some help.
This time I'm trying to get system info via WMI with Excel VBA and I wanted to ask some advices.
My goal is to list all values for each property of a give WMI.Win32_xxxx class.
My question is about how to get all the keys for all properties listed without actually write in my code all properties' names.
I explain myself better, I have the code below:
It's a simple code in which I call a function passing the class I want to list the properties' values from.![]()
Please Login or Register to view this content.
Since the class Win32_OperatingSystem contains 63 properties, I'm wondering if is there a way to loop through all of them in order to get those data without writing all the names of the properties.
I mean, something like:
Unluckily this code doesn't work because I'm not referencing correctly the structure of the class.![]()
Please Login or Register to view this content.
Any help would be highly appreciated.
regards,
PP
Bookmarks