View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
stabilo stabilo is offline
external usenet poster
 
Posts: 14
Default Get IP address for a remote computer based on its hostname

I'd like to get, with VBA, the IP address(es) if a computer based on its
hostname :

eg. Cell "a1" = PCXXX
Cell "a2" = XX.XX.XX.XX

I have seen some example that put the result of a ping into a text file,
then pars this text file and put in cells the ip address into a cell.

Is there another way ? I'm using Excel 2003