LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Convert IP Address to Host Name

I'm trying to use Excel to process a list of IP addresses and return a
column of host names.

I have other tools that do this, but the list of addresses is usually parsed
in Excel, so I thought that it would save time to use Excel for the complete
task.

I've looked through many sites but have not come up with a solution. For
instance there may be a VBA script that does this, but I am not able to get
this to work in Excel:

http://vbnet.mvps.org/code/network/hostnamefromip.htm

I have other tools that do this, but the list of addresses is usually parsed
in Excel, so I thought that it would save time to use Excel for the complete
task.

Thanks for any help.

Ed


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert text string to IP address Mike Excel Worksheet Functions 3 September 22nd 09 03:02 AM
Looking for a formula that will convert IP address for sorting metelcom Excel Discussion (Misc queries) 7 January 6th 08 07:57 PM
Function to convert to email address? [email protected] Excel Worksheet Functions 4 November 12th 07 08:39 PM
Convert Relative to absolute address Yorke Excel Discussion (Misc queries) 6 October 25th 07 07:47 PM
how can i convert an email address to a web address Arvind Sikar Excel Worksheet Functions 3 October 3rd 06 08:06 PM


All times are GMT +1. The time now is 11:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"