Sub GetCompInfo()
Dim objWMIService, colOS, objOS
Set objWMIService = GetObject("winmgmts:" _
& "{impersonationLevel=impersonate}!\\.\root\cimv2")
Set colOS = objWMIService.ExecQuery _
("SELECT * FROM Win32_OperatingSystem")
For Each objOS In colOS
MsgBox " Name : " & objOS.Caption & vbCrLf & _
" OSType : " & objOS.OSType & vbCrLf & _
" Version : " & objOS.Version & vbCrLf & _
" BuildNumber :" & objOS.BuildNumber & vbCrLf & _
" CSDVersion : " & objOS.CSDVersion & vbCrLf & _
" ServicePackMajorVersion : " & objOS.ServicePackMajorVersion & vbCrLf & _
" ServicePackMinorVersion : " & objOS.ServicePackMinorVersion & vbCrLf & _
" CSName : " & objOS.CSName & vbCrLf & _
" TotalSwapSpaceSize : " & objOS.TotalSwapSpaceSize & vbCrLf & _
" TotalVirtualMemorySize : " & objOS.TotalVirtualMemorySize & vbCrLf & _
" TotalVisibleMemorySize : " & objOS.TotalVisibleMemorySize & vbCrLf & _
" FreePhysicalMemory : " & objOS.FreePhysicalMemory & vbCrLf & _
" FreeSpaceInPagingFiles : " & objOS.FreeSpaceInPagingFiles & vbCrLf & _
" FreePhysicalMemory : " & objOS.FreePhysicalMemory & vbCrLf & _
" FreeVirtualMemory : " & objOS.FreeVirtualMemory
Next