Hello:
Is there a way to use the following code, without using the For Each loop?
Can we access a single Item from the collection, without making it in to a collection?
Code:Set objWMIService = GetObject("winmgmts:\\.\root\cimv2") Set colItems = objWMIService.ExecQuery("Select * from Win32_ComputerSystem") Debug.Print colItems.Caption 'Why can't we just do it like this? <<<<<<<< For Each objItem In colItems debug.print objitem.Caption 'Only this method works.... Next