Randy Birch's original works fine for me in Win10. If you're using Excel64
you would of course need to adapt the APIs, pointers and pointer lengths.

Peter T


wrote in message
...
On Monday, 12 April 2010 13:20:38 UTC+1, nicktruman wrote:
Thanks i will give that a go, it actually took 45 mins for all 400, which
can't be right.

Nick

---
frmsrcurl:
http://msgroups.net/microsoft.public...tname-in-Excel

I've found that all attempts to get a host-name from an IP address that
use CopyMemory form within Excel just crash Excel. Using W10 anyway...

Other solutions rely on access to the command prompt which my environment
does not have. Are there any other solutions?