Function to convert IP Address to Hostname (64 bit)

[NewOrderFac33]

Good afternoon - since our upgrade to Win 10/Office 2016 64 bit, a lot of my functions, including those to extract IP addresses from HostNames and vice versa no longer work (no surprise there, then)

Even when I add PtrSafe to my existing functions that worked in Win7/Office 2010 32 bit, the Excel instance just crashes.

I've Googled for a while, and whilst I have found a function to extract the IP address from a HostName, I still haven't been able to find a function to do the reverse, so, can any of you nice folks out there help me, please?

P.S. Any HostName->IP functions that are neater than what I already have would also be welcome!

Thanks in advance

Pete

 

[NewOrderFac33]

Kenneth - this also works fine - thanks very much!
Pete

 

[NewOrderFac33]

Rory - slight problem - your solution works for Windows hosts, but not Linux ones!