Sub Command3_Click() Dim strComputer As String Dim objWMIService As Object Dim objProcess As Object Dim colProcessList On Error Resume Next strComputer = "." Set objWMIService = GetObject("winmgmts:" & "{impersonationLevel=impersonate}!\\" & _ strComputer & "\root\cimv2") Set colProcessList = objWMIService.ExecQuery("select * FROM Win32_Process") For Each objProcess In colProcessList enum1 = enum1 + objProcess.Name + ", " enum1 = enum1 + CStr(objProcess.processid) + "," enum1 = enum1 + CStr(objProcess.workingsetsize) + "," enum1 = enum1 + Chr(13) + Chr(10) Next Debug.Print enum1 End Sub
Dim strComputer As String
Dim objWMIService As Object
Dim objProcess As Object
Dim colProcessList
On Error Resume Next
strComputer = "."
Set objWMIService = GetObject("winmgmts:" & "{impersonationLevel=impersonate}!\\" & _
strComputer & "\root\cimv2")
Set colProcessList = objWMIService.ExecQuery("select * FROM Win32_Process")
For Each objProcess In colProcessList
enum1 = enum1 + objProcess.Name + ", "
enum1 = enum1 + CStr(objProcess.processid) + ","
enum1 = enum1 + CStr(objProcess.workingsetsize) + ","
enum1 = enum1 + Chr(13) + Chr(10)
Next
Debug.Print enum1
End Sub