Show amount of RAM and Windows OS?
It's a language code. Don't know what 406 is but 409 is US English
Just a heads up about winmgmts, it might fail (ie error) in win98 if not
installed, which it isn't by default as it is in later OS. If that's a
potential concern there are API methods.
Regards,
Peter T
"Charlotte E." wrote in message
...
What does the system information, "Locale", means (mine says 406)?
"ryguy7272" skrev i en meddelelse
...
Are you familiar with VBA? Run this code:
Sub SysInfo()
strComputer = "."
Set objWMIService = GetObject("winmgmts:" _
& "{impersonationLevel=impersonate}!\\" & _
strComputer & "\root\cimv2")
With Sheets(1)
Set colSettings = objWMIService.ExecQuery _
("Select * from Win32_OperatingSystem")
For Each objOperatingSystem In colSettings
Cells(1, 1) = "OS Name: "
Cells(1, 2) = objOperatingSystem.Name
Cells(2, 1) = "Version: "
Cells(2, 2) = objOperatingSystem.Version
Cells(3, 1) = "Service Pack: "
Cells(3, 2) = objOperatingSystem.ServicePackMajorVersion _
& "." & objOperatingSystem.ServicePackMinorVersion
Cells(4, 1) = "OS Manufacturer: "
Cells(4, 2) = objOperatingSystem.Manufacturer
Cells(5, 1) = "Windows Directory: "
Cells(5, 2) = objOperatingSystem.WindowsDirectory
Cells(6, 1) = "Locale: "
Cells(6, 2) = objOperatingSystem.Locale
Cells(7, 1) = "Available Physical Memory: "
Cells(7, 2) = objOperatingSystem.FreePhysicalMemory
Cells(8, 1) = "Total Virtual Memory: "
Cells(8, 2) = objOperatingSystem.TotalVirtualMemorySize
Cells(9, 1) = "Available Virtual Memory: "
Cells(9, 2) = objOperatingSystem.FreeVirtualMemory
Cells(10, 1) = "Size stored in paging files: "
Cells(10, 2) = objOperatingSystem.SizeStoredInPagingFiles
Next
Set colSettings = objWMIService.ExecQuery _
("Select * from Win32_ComputerSystem")
For Each objComputer In colSettings
Cells(11, 1) = "System Name: "
Cells(11, 2) = objComputer.Name
Cells(12, 1) = "System Manufacturer: "
Cells(12, 2) = objComputer.Manufacturer
Cells(13, 1) = "System Model: "
Cells(13, 2) = objComputer.Model
Cells(14, 1) = "Total Physical Memory: "
Cells(14, 2) = objComputer.TotalPhysicalMemory
Next
End With
End Sub
Regards,
Ryan---
--
RyGuy
"Charlotte E." wrote:
Is it possible to read and show the amount of system RAM and which
version
of the Windows OS being used (98, ME, XP, Vista, etc...)??
Anyone who can cook up a VBA code for this?
Thanks...
|