Code snippet to return IP and Hostname lookup in excel. Change the sheet name and ranges as needed. Can take some time to run on big lists! Function GetPingResult(Host) Dim objPing As Object Dim objStatus As Object Dim Result As String ‘ping the host Set objPing = GetObject(“winmgmts:{impersonationLevel=impersonate}”). _ ExecQuery(“Select * from Win32_PingStatus Where […]