these links might be better:
http://stackoverflow.com/questions/7...uration-in-vba
http://technet.microsoft.com/en-us/l.../ee176998.aspx
http://www.google.com/#pq=winmgmts%2...w=1280&bih=737
http://www.google.com/#sclient=psy&h...w=1280&bih=737
I tried it on my machine and I got this for the processor item:
Code:
Intel(R) Pentium(R) Dual CPU T3200 @ 2.00GHz, Intel Processor, Intel, intelppm
the code I used to try it:
Code:
Sub ff()
Set svc = GetObject("winmgmts:root\cimv2")
Set objenum = svc.execQuery("select * from Win32_PnPEntity")
For Each obj In objenum
Debug.Print obj.Name & ", " & obj.Description & ", " & obj.manufacturer & ", " & obj.service
Next
End Sub
and actually, there is a one-liner API call in VBA to get the amount of RAM, if I remember right. I have a list of a few hundred API calls, but I don't have it right now...sorry.