Excel tip: Getting the processor speed
Date: 13 january 2002The following code will show you the processor name and speed of you computer. The code has been posted in the Microsoft Excel Developers List by by Julian Milano.
This code uses Windows Management Instrumentation (WMI), which was introduced in Windows 2000.
Sub ProcessorSpeed()
' shows the processor name and speed of the computer
Dim MyOBJ As Object
Dim cpu As Object
Set MyOBJ = GetObject("WinMgmts:").instancesof("Win32_Processor")
For Each cpu In MyOBJ
MsgBox cpu.Name & " " & cpu.CurrentClockSpeed & " Mhz", vbInformation
Next
End Sub
' shows the processor name and speed of the computer
Dim MyOBJ As Object
Dim cpu As Object
Set MyOBJ = GetObject("WinMgmts:").instancesof("Win32_Processor")
For Each cpu In MyOBJ
MsgBox cpu.Name & " " & cpu.CurrentClockSpeed & " Mhz", vbInformation
Next
End Sub
« back