jbirkku
asked on
Get computer system and hardware information using Exel VBA
I'm trying write a macro to get my computer system and hardware information. Currently, I have the below code. However, it doesn't provide the graphic card information, and computer information like processor speed, amount of RAM (ex. Intel(R) Core(TM)2 Duo CPU P8700 @ 2.53 GHz, 3.45 GB of RAM, etc..). Is there a way to do this?
Thanks.
Sub GetCInfo()
Dim i As Long, y As String, count As Variant
count = 1
For i = 1 To 39
Range("A" & count) = Environ(i)
count = count + 1
Next
End Sub
Thanks.
Sub GetCInfo()
Dim i As Long, y As String, count As Variant
count = 1
For i = 1 To 39
Range("A" & count) = Environ(i)
count = count + 1
Next
End Sub
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks! I could find all the information I needed except for the amount of RAM installed. Using WMI, Do you know where I can find this information?
RAM is in a few places, but its stored as bytes.I believe it is in system, BIOS among others. Once you have it, you then need to truncated the number, round it or do the real math to covert it from 3.45 billion bytes (3450000000000) to a gb form.
ASKER