You can use wscipt.shell to execute the command and get the output using stdout.readall method.
here is some guidelines you can use -
1. get the host name and ip address from excel
2. Execute the ns lookup command with the returned host name
3. Get the output with stdout
4. Parse the ip address and compare
here is some guidelines you can use -
1. get the host name and ip address from excel
2. Execute the ns lookup command with the returned host name
3. Get the output with stdout
4. Parse the ip address and compare