Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #111720
| From | "Peter T" <askmy@email.com> |
|---|---|
| Newsgroups | microsoft.public.excel.programming |
| Subject | Re: IP address to Hostname in Excel |
| Date | 2020-11-10 17:26 +0000 |
| Organization | A noiseless patient Spider |
| Message-ID | <roeicp$rlo$1@dont-email.me> (permalink) |
| References | (5 earlier) <ockmch$pt8$1@dont-email.me> <3dcdebb2-cb2f-424b-9813-c83da3037980@googlegroups.com> <ocndje$9q1$1@dont-email.me> <3891e0a6-cd20-46e6-97a9-5cc827fd64eb@googlegroups.com> <4525b194-ea3c-474d-ade0-10e5298c530dn@googlegroups.com> |
"Andrey G" <andrey.gorodnichev2@gmail.com> wrote in message > On Friday, April 14, 2017 at 12:39:40 AM UTC+1, theurlo...@googlemail.com > wrote: >> Agreed - thanks Randy and apologies for the confusion re Windows/Office >> versions :) >> >> Simon > > Dear all, > At work, I've inherited the file that's using Randy Birch's code from > here: http://vbnet.mvps.org/index.html?code/internet/pingbyhostname.htm. > Recently, all machines have been up-dated to Office 64 bit and the code > stopped working. > I've tried everything from Peter T suggestions above, but, still, as soon > as the code gets to line: CopyMemory ptrName, ByVal ptrName, 4, Excel > crashes. > I feel particularly stupid, as it looks that some people in this > conversation have actually managed to adjust original code to 64 bit, > following Peter T's advice. > Any help will be greatly appreciated! > > Andrey G What were my 'suggestions above'...? It looks like you're attempting to copy a pointer which in x64 will be an 8-bit LongLong, or a 4-bit Long in x32 Try declaring this conditional constant, either as public in a normal module or as private in the module you call CopyMemory #If Win64 Then Public Const gcPtrBytes As Long = 8 #Else Public Const gcPtrBytes As Long = 4 #End If and CopyMemory ptrName, ByVal ptrName, gcPtrBytes Only a guess with not much to go on! Peter T
Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
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
csiph-web