Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > microsoft.public.excel.programming > #109984

Re: IP address to Hostname in Excel

From "Peter T" <askformy@gmail.com>
Newsgroups microsoft.public.excel.programming
Subject Re: IP address to Hostname in Excel
Date 2017-04-10 11:25 +0100
Organization A noiseless patient Spider
Message-ID <ocfmc0$jlu$1@dont-email.me> (permalink)
References <#UrrP9T2KHA.4332@TK2MSFTNGP02.phx.gbl> <enCgQqj2KHA.4752@TK2MSFTNGP02.phx.gbl> <4e437bb8-74e6-4a87-b5d5-462b2d46956a@googlegroups.com>

Show all headers | View raw


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


<theurlofealing@googlemail.com> wrote in message 
news:4e437bb8-74e6-4a87-b5d5-462b2d46956a@googlegroups.com...
> 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.excel.programming/IP-address-to-Hostname-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? 

Back to microsoft.public.excel.programming | Previous | NextPrevious in thread | Next in thread | Find similar | Unroll thread


Thread

Re: IP address to Hostname in Excel theurlofealing@googlemail.com - 2017-04-10 01:14 -0700
  Re: IP address to Hostname in Excel "Peter T" <askformy@gmail.com> - 2017-04-10 11:25 +0100
    Re: IP address to Hostname in Excel theurlofealing@googlemail.com - 2017-04-11 12:23 -0700
      Re: IP address to Hostname in Excel "Peter T" <askformy@gmail.com> - 2017-04-12 08:55 +0100
        Re: IP address to Hostname in Excel theurlofealing@googlemail.com - 2017-04-12 11:52 -0700
          Re: IP address to Hostname in Excel "Peter T" <askformy@gmail.com> - 2017-04-13 09:44 +0100
            Re: IP address to Hostname in Excel theurlofealing@googlemail.com - 2017-04-13 16:39 -0700
              Re: IP address to Hostname in Excel Andrey G <andrey.gorodnichev2@gmail.com> - 2020-11-10 06:45 -0800
                Re: IP address to Hostname in Excel "Peter T" <askmy@email.com> - 2020-11-10 17:26 +0000
                Re: IP address to Hostname in Excel "Auric__" <not.my.real@email.address> - 2020-11-10 17:40 +0000
                Re: IP address to Hostname in Excel "Peter T" <askmy@email.com> - 2020-11-11 10:16 +0000
                Re: IP address to Hostname in Excel Andrey G <andrey.gorodnichev2@gmail.com> - 2020-11-10 10:54 -0800
                Re: IP address to Hostname in Excel "Auric__" <not.my.real@email.address> - 2020-11-10 20:00 +0000
                Re: IP address to Hostname in Excel "Peter T" <askmy@email.com> - 2020-11-11 11:39 +0000
                Re: IP address to Hostname in Excel Andrey G <andrey.gorodnichev2@gmail.com> - 2020-11-11 04:11 -0800
                Re: IP address to Hostname in Excel "Peter T" <askmy@email.com> - 2020-11-12 11:38 +0000
                Re: IP address to Hostname in Excel Andrey G <andrey.gorodnichev2@gmail.com> - 2020-11-12 04:10 -0800
                Re: IP address to Hostname in Excel "Peter T" <askmy@email.com> - 2020-11-18 10:02 +0000
                Re: IP address to Hostname in Excel Andrey G <andrey.gorodnichev2@gmail.com> - 2020-11-18 13:25 -0800
                Re: IP address to Hostname in Excel "Peter T" <askmy@email.com> - 2020-11-18 22:51 +0000
                Re: IP address to Hostname in Excel Andrey G <andrey.gorodnichev2@gmail.com> - 2020-11-22 11:33 -0800
                Re: IP address to Hostname in Excel "Peter T" <askmy@email.com> - 2020-11-23 14:37 +0000
                Re: IP address to Hostname in Excel Andrey G <andrey.gorodnichev2@gmail.com> - 2020-11-24 01:50 -0800
      Re: IP address to Hostname in Excel birchr@gmail.com - 2017-04-12 12:27 -0700

csiph-web