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
©1999-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.