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-2024 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
Empowering Excel Users Worldwide for 25 Years
Empowering Excel Users Worldwide for 25 Years