Steffmeister
Board Regular
- Joined
- Nov 7, 2005
- Messages
- 195
Hi everybody,
I've got a question about nslookup in Excel.
I've got 1 column (A) with IP-addresses and I want to have a hostname of it. In cmd I can fill in nslookup xxx.xxx.xxx.xxx but that is too much work for me, because it is a lot of addresses. Is it possible that Excel can get a range of addresses with hostname via nslookup? The results must come in Sheet 2 if that is possible?
Does anybody have a VBA code for this?
Tnx for now,
Steffmeister
I've got a question about nslookup in Excel.
I've got 1 column (A) with IP-addresses and I want to have a hostname of it. In cmd I can fill in nslookup xxx.xxx.xxx.xxx but that is too much work for me, because it is a lot of addresses. Is it possible that Excel can get a range of addresses with hostname via nslookup? The results must come in Sheet 2 if that is possible?
Does anybody have a VBA code for this?
Tnx for now,
Steffmeister