Get computer system and hardware information using Exel VBA
Posted on 2012-08-30
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?
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