A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Programming
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

IP address to Hostname in Excel



 
 
Thread Tools Display Modes
  #1  
Old April 11th 10, 07:22 AM posted to microsoft.public.excel.programming
nicktruman
external usenet poster
 
Posts: 6
Default IP address to Hostname in Excel

Hi,
I am hoping someone can help me please..
I have a spreadsheet that is linked to a survey being hosted on our website.
The survey is about internet safety and one of the questions it ask is what
is your ISP? However it seems that not everyone here in Bahrain knows this
and their entries are not valid. However we trap the IP addess in the survey
results and these are pulled into the spreadsheet along with all the survey
answers.

column a col b col c col d
IP Address Sex Age Nationality etc..
193.188.105.25 M 32 Bahraini etc..
84.235.101.66 M 33 Lebanese
83.136.59.145 F 28 Bahraini

I want to find a way of converting the IP Address into an ISP name or at
least the hostname. Can anyone help?
Cheers in advance
Nick


---
frmsrcurl: http://msgroups.net/microsoft.public.excel.programming/
Ads
  #2  
Old April 11th 10, 12:12 PM posted to microsoft.public.excel.programming
joel[_876_]
external usenet poster
 
Posts: 1
Default IP address to Hostname in Excel


You can get the PC Name by usding the environmental variable
COMPUTERNAME


computerName = environ("COMPUTERNAME")


You can get the IP address from the computername by doing a ipconfig
command to the host name. From a sheel prompt

1) Start - run - c:\windos\system32\cmd.exe
2) ipconfig


You can run these commands from a sheel command like this

ComputerName = Environ("ComputerName")

Shell "cmd /c C:\windows\system32\ipconfig >c:\temp\ipconfig.txt", 0


You can then open the text file to get the results.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=194661

http://www.thecodecage.com/forumz

  #3  
Old April 11th 10, 12:34 PM posted to microsoft.public.excel.programming
nicktruman
external usenet poster
 
Posts: 6
Default IP address to Hostname in Excel

Hi, Thanks for the reply.
However, I a not after my data, but the hostnames of IP addresses registered in a survey by people who have filled in a survey.

Cheers
Nick

---
frmsrcurl: http://msgroups.net/microsoft.public...tname-in-Excel
  #4  
Old April 11th 10, 01:08 PM posted to microsoft.public.excel.programming
joel[_877_]
external usenet poster
 
Posts: 1
Default IP address to Hostname in Excel


what I did recently in C# was to ping the IP addrress which filled up
the ARP table. Then went into the ARP table to get the Host Names. It
is posible to do the same thing uisng VBA but will have to think about
the process.

I aslo can open an Excel file from C#. so I could write a C# program
which opens your excel file get the IP address, ping the addresses, and
then read the arp table.

Likewise, from VBA I could use the Shell command to ping each of the IP
addresses then read the arp table. To read the ARP table I would use a
DLL in the system32 folder to get the results. there also may be a
reference library that would read the arp table but would need to
investigate some more.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=194661

http://www.thecodecage.com/forumz

  #5  
Old April 11th 10, 01:19 PM posted to microsoft.public.excel.programming
nicktruman
external usenet poster
 
Posts: 6
Default IP address to Hostname in Excel

Thnaks Joel. I tried calling wsock32 but this is a 64 bit machine and I got errors on teh library.
I saw some code gethostnamefromIp but could not make it work in Excel.
I have 800+ IP addresses to check and output some sort of data.
I guess similar to an excel version of ping -a
where the output would be (as in this case (dhcp.trcy.mi.charter.com)

ping -a 24.236.213.225
Pinging 24-236-213-225.dhcp.trcy.mi.charter.com

---
frmsrcurl: http://msgroups.net/microsoft.public...tname-in-Excel
  #6  
Old April 11th 10, 03:10 PM posted to microsoft.public.excel.programming
joel[_878_]
external usenet poster
 
Posts: 1
Default IP address to Hostname in Excel


I found code on the web that works fine. I added a routing at the end
to test the code.


'''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''
' Copyright 1996-2009 VBnet, Randy Birch, All Rights Reserved.
' Some pages may also contain other copyrights by the author.
'''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''
' Distribution: You can freely use this code in your own
' applications, but you may not reproduce
' or publish this code on any web site,
' online service, or distribute as source
' on any media without express permission.
'''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''
Private Const WSADescription_Len As Long = 256
Private Const WSASYS_Status_Len As Long = 128
Private Const WS_VERSION_REQD As Long = &H101
Private Const IP_SUCCESS As Long = 0
Private Const SOCKET_ERROR As Long = -1
Private Const AF_INET As Long = 2

Private Type WSADATA
wVersion As Integer
wHighVersion As Integer
szDescription(0 To WSADescription_Len) As Byte
szSystemStatus(0 To WSASYS_Status_Len) As Byte
imaxsockets As Integer
imaxudp As Integer
lpszvenderinfo As Long
End Type

Private Declare Function WSAStartup Lib "wsock32" _
(ByVal VersionReq As Long, _
WSADataReturn As WSADATA) As Long

Private Declare Function WSACleanup Lib "wsock32" () As Long

Private Declare Function inet_addr Lib "wsock32" _
(ByVal s As String) As Long

Private Declare Function gethostbyaddr Lib "wsock32" _
(haddr As Long, _
ByVal hnlen As Long, _
ByVal addrtype As Long) As Long

Private Declare Sub CopyMemory Lib "kernel32" _
Alias "RtlMoveMemory" _
(xDest As Any, _
xSource As Any, _
ByVal nbytes As Long)

Private Declare Function lstrlen Lib "kernel32" _
Alias "lstrlenA" _
(lpString As Any) As Long



Private Sub Command1_Click()

Text2.Text = GetHostNameFromIP(Text1.Text)

End Sub


Private Function SocketsInitialize() As Boolean

Dim WSAD As WSADATA

SocketsInitialize = WSAStartup(WS_VERSION_REQD, WSAD) = IP_SUCCESS

End Function


Private Sub SocketsCleanup()

If WSACleanup() <> 0 Then
MsgBox "Windows Sockets error occurred in Cleanup.",
vbExclamation
End If

End Sub


Private Function GetHostNameFromIP(ByVal sAddress As String) As String

Dim ptrHosent As Long
Dim hAddress As Long
Dim nbytes As Long

If SocketsInitialize() Then

'convert string address to long
hAddress = inet_addr(sAddress)

If hAddress <> SOCKET_ERROR Then

'obtain a pointer to the HOSTENT structure
'that contains the name and address
'corresponding to the given network address.
ptrHosent = gethostbyaddr(hAddress, 4, AF_INET)

If ptrHosent <> 0 Then

'convert address and
'get resolved hostname
CopyMemory ptrHosent, ByVal ptrHosent, 4
nbytes = lstrlen(ByVal ptrHosent)

If nbytes > 0 Then
sAddress = Space$(nbytes)
CopyMemory ByVal sAddress, ByVal ptrHosent, nbytes
GetHostNameFromIP = sAddress
End If

Else
MsgBox "Call to gethostbyaddr failed."
End If 'If ptrHosent

SocketsCleanup

Else
MsgBox "String passed is an invalid IP."
End If 'If hAddress

Else
MsgBox "Sockets failed to initialize."
End If 'If SocketsInitialize

End Function

Sub test()
MsgBox (GetHostNameFromIP("192.168.1.30"))

End Sub


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=194661

http://www.thecodecage.com/forumz

  #7  
Old April 11th 10, 06:56 PM posted to microsoft.public.excel.programming
JLatham
external usenet poster
 
Posts: 2,204
Default IP address to Hostname in Excel

Joel,
Nice find. I looked for something like that and was not successful. Do you
have the URL for the site?

I've modified it to work off of an Excel sheet vs through a form and tested
with the 32-bit version of Office/Excel under both Vista Home Premium x64 and
Windows 7 Ultimate x64 and it works fine. However, in a virtual machine
running Windows 7 Pro x64 with the Office/Excel 2010 Beta, the code won't
compile and markes all API declarations as errors with this message:

Compiler error:
The code in this project must be updated for use on 64-bit systems.
Please review and update Declare statements and then mark them with
the PtrSafe attribute.

Guess I'll have to dig into the x64 API's and see if I can't figure out how
to change that section, plus I'll have to research the "PtrSafe" attribute,
which the Help in 2010 VBA gave no reference to and couldn't find it on
on-line help either.

"joel" wrote:

>
> I found code on the web that works fine. I added a routing at the end
> to test the code.
>
>
> '''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''
> ' Copyright ©1996-2009 VBnet, Randy Birch, All Rights Reserved.
> ' Some pages may also contain other copyrights by the author.
> '''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''
> ' Distribution: You can freely use this code in your own
> ' applications, but you may not reproduce
> ' or publish this code on any web site,
> ' online service, or distribute as source
> ' on any media without express permission.
> '''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''
> Private Const WSADescription_Len As Long = 256
> Private Const WSASYS_Status_Len As Long = 128
> Private Const WS_VERSION_REQD As Long = &H101
> Private Const IP_SUCCESS As Long = 0
> Private Const SOCKET_ERROR As Long = -1
> Private Const AF_INET As Long = 2
>
> Private Type WSADATA
> wVersion As Integer
> wHighVersion As Integer
> szDescription(0 To WSADescription_Len) As Byte
> szSystemStatus(0 To WSASYS_Status_Len) As Byte
> imaxsockets As Integer
> imaxudp As Integer
> lpszvenderinfo As Long
> End Type
>
> Private Declare Function WSAStartup Lib "wsock32" _
> (ByVal VersionReq As Long, _
> WSADataReturn As WSADATA) As Long
>
> Private Declare Function WSACleanup Lib "wsock32" () As Long
>
> Private Declare Function inet_addr Lib "wsock32" _
> (ByVal s As String) As Long
>
> Private Declare Function gethostbyaddr Lib "wsock32" _
> (haddr As Long, _
> ByVal hnlen As Long, _
> ByVal addrtype As Long) As Long
>
> Private Declare Sub CopyMemory Lib "kernel32" _
> Alias "RtlMoveMemory" _
> (xDest As Any, _
> xSource As Any, _
> ByVal nbytes As Long)
>
> Private Declare Function lstrlen Lib "kernel32" _
> Alias "lstrlenA" _
> (lpString As Any) As Long
>
>
>
> Private Sub Command1_Click()
>
> Text2.Text = GetHostNameFromIP(Text1.Text)
>
> End Sub
>
>
> Private Function SocketsInitialize() As Boolean
>
> Dim WSAD As WSADATA
>
> SocketsInitialize = WSAStartup(WS_VERSION_REQD, WSAD) = IP_SUCCESS
>
> End Function
>
>
> Private Sub SocketsCleanup()
>
> If WSACleanup() <> 0 Then
> MsgBox "Windows Sockets error occurred in Cleanup.",
> vbExclamation
> End If
>
> End Sub
>
>
> Private Function GetHostNameFromIP(ByVal sAddress As String) As String
>
> Dim ptrHosent As Long
> Dim hAddress As Long
> Dim nbytes As Long
>
> If SocketsInitialize() Then
>
> 'convert string address to long
> hAddress = inet_addr(sAddress)
>
> If hAddress <> SOCKET_ERROR Then
>
> 'obtain a pointer to the HOSTENT structure
> 'that contains the name and address
> 'corresponding to the given network address.
> ptrHosent = gethostbyaddr(hAddress, 4, AF_INET)
>
> If ptrHosent <> 0 Then
>
> 'convert address and
> 'get resolved hostname
> CopyMemory ptrHosent, ByVal ptrHosent, 4
> nbytes = lstrlen(ByVal ptrHosent)
>
> If nbytes > 0 Then
> sAddress = Space$(nbytes)
> CopyMemory ByVal sAddress, ByVal ptrHosent, nbytes
> GetHostNameFromIP = sAddress
> End If
>
> Else
> MsgBox "Call to gethostbyaddr failed."
> End If 'If ptrHosent
>
> SocketsCleanup
>
> Else
> MsgBox "String passed is an invalid IP."
> End If 'If hAddress
>
> Else
> MsgBox "Sockets failed to initialize."
> End If 'If SocketsInitialize
>
> End Function
>
> Sub test()
> MsgBox (GetHostNameFromIP("192.168.1.30"))
>
> End Sub
>
>
> --
> joel
> ------------------------------------------------------------------------
> joel's Profile: 229
> View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=194661
>
> http://www.thecodecage.com/forumz
>
> .
>

  #8  
Old April 11th 10, 07:13 PM posted to microsoft.public.excel.programming
JLatham
external usenet poster
 
Posts: 2,204
Default IP address to Hostname in Excel

Never mind the request for the URL, found it:
http://vbnet.mvps.org/code/network/hostnamefromip.htm


"joel" wrote:

>
> I found code on the web that works fine. I added a routing at the end
> to test the code.
>
>
> '''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''
> ' Copyright ©1996-2009 VBnet, Randy Birch, All Rights Reserved.
> ' Some pages may also contain other copyrights by the author.
> '''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''
> ' Distribution: You can freely use this code in your own
> ' applications, but you may not reproduce
> ' or publish this code on any web site,
> ' online service, or distribute as source
> ' on any media without express permission.
> '''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''
> Private Const WSADescription_Len As Long = 256
> Private Const WSASYS_Status_Len As Long = 128
> Private Const WS_VERSION_REQD As Long = &H101
> Private Const IP_SUCCESS As Long = 0
> Private Const SOCKET_ERROR As Long = -1
> Private Const AF_INET As Long = 2
>
> Private Type WSADATA
> wVersion As Integer
> wHighVersion As Integer
> szDescription(0 To WSADescription_Len) As Byte
> szSystemStatus(0 To WSASYS_Status_Len) As Byte
> imaxsockets As Integer
> imaxudp As Integer
> lpszvenderinfo As Long
> End Type
>
> Private Declare Function WSAStartup Lib "wsock32" _
> (ByVal VersionReq As Long, _
> WSADataReturn As WSADATA) As Long
>
> Private Declare Function WSACleanup Lib "wsock32" () As Long
>
> Private Declare Function inet_addr Lib "wsock32" _
> (ByVal s As String) As Long
>
> Private Declare Function gethostbyaddr Lib "wsock32" _
> (haddr As Long, _
> ByVal hnlen As Long, _
> ByVal addrtype As Long) As Long
>
> Private Declare Sub CopyMemory Lib "kernel32" _
> Alias "RtlMoveMemory" _
> (xDest As Any, _
> xSource As Any, _
> ByVal nbytes As Long)
>
> Private Declare Function lstrlen Lib "kernel32" _
> Alias "lstrlenA" _
> (lpString As Any) As Long
>
>
>
> Private Sub Command1_Click()
>
> Text2.Text = GetHostNameFromIP(Text1.Text)
>
> End Sub
>
>
> Private Function SocketsInitialize() As Boolean
>
> Dim WSAD As WSADATA
>
> SocketsInitialize = WSAStartup(WS_VERSION_REQD, WSAD) = IP_SUCCESS
>
> End Function
>
>
> Private Sub SocketsCleanup()
>
> If WSACleanup() <> 0 Then
> MsgBox "Windows Sockets error occurred in Cleanup.",
> vbExclamation
> End If
>
> End Sub
>
>
> Private Function GetHostNameFromIP(ByVal sAddress As String) As String
>
> Dim ptrHosent As Long
> Dim hAddress As Long
> Dim nbytes As Long
>
> If SocketsInitialize() Then
>
> 'convert string address to long
> hAddress = inet_addr(sAddress)
>
> If hAddress <> SOCKET_ERROR Then
>
> 'obtain a pointer to the HOSTENT structure
> 'that contains the name and address
> 'corresponding to the given network address.
> ptrHosent = gethostbyaddr(hAddress, 4, AF_INET)
>
> If ptrHosent <> 0 Then
>
> 'convert address and
> 'get resolved hostname
> CopyMemory ptrHosent, ByVal ptrHosent, 4
> nbytes = lstrlen(ByVal ptrHosent)
>
> If nbytes > 0 Then
> sAddress = Space$(nbytes)
> CopyMemory ByVal sAddress, ByVal ptrHosent, nbytes
> GetHostNameFromIP = sAddress
> End If
>
> Else
> MsgBox "Call to gethostbyaddr failed."
> End If 'If ptrHosent
>
> SocketsCleanup
>
> Else
> MsgBox "String passed is an invalid IP."
> End If 'If hAddress
>
> Else
> MsgBox "Sockets failed to initialize."
> End If 'If SocketsInitialize
>
> End Function
>
> Sub test()
> MsgBox (GetHostNameFromIP("192.168.1.30"))
>
> End Sub
>
>
> --
> joel
> ------------------------------------------------------------------------
> joel's Profile: 229
> View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=194661
>
> http://www.thecodecage.com/forumz
>
> .
>

  #9  
Old April 11th 10, 07:57 PM posted to microsoft.public.excel.programming
JLatham
external usenet poster
 
Posts: 2,204
Default IP address to Hostname in Excel

I found the cure in a 'pure' 64-bit world.
The VM I have set up (in VMWare's Player) uses 64-bit Windows 7 Ultimate and
the 64-bit Beta version of Office/Excel.
To get the code to run in that environment you have to change all of the
Private Declare
statements to
Private Declare PtrSafe
and then it compiles and runs just fine in the 64-bit world (but not in
32-bit Excel 2007, which doesn't seem to recognize "PtrSafe" at all).


"JLatham" wrote:

> Joel,
> Nice find. I looked for something like that and was not successful. Do you
> have the URL for the site?
>
> I've modified it to work off of an Excel sheet vs through a form and tested
> with the 32-bit version of Office/Excel under both Vista Home Premium x64 and
> Windows 7 Ultimate x64 and it works fine. However, in a virtual machine
> running Windows 7 Pro x64 with the Office/Excel 2010 Beta, the code won't
> compile and markes all API declarations as errors with this message:
>
> Compiler error:
> The code in this project must be updated for use on 64-bit systems.
> Please review and update Declare statements and then mark them with
> the PtrSafe attribute.
>
> Guess I'll have to dig into the x64 API's and see if I can't figure out how
> to change that section, plus I'll have to research the "PtrSafe" attribute,
> which the Help in 2010 VBA gave no reference to and couldn't find it on
> on-line help either.
>
> "joel" wrote:
>
> >
> > I found code on the web that works fine. I added a routing at the end
> > to test the code.
> >
> >
> > '''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''
> > ' Copyright ©1996-2009 VBnet, Randy Birch, All Rights Reserved.
> > ' Some pages may also contain other copyrights by the author.
> > '''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''
> > ' Distribution: You can freely use this code in your own
> > ' applications, but you may not reproduce
> > ' or publish this code on any web site,
> > ' online service, or distribute as source
> > ' on any media without express permission.
> > '''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''
> > Private Const WSADescription_Len As Long = 256
> > Private Const WSASYS_Status_Len As Long = 128
> > Private Const WS_VERSION_REQD As Long = &H101
> > Private Const IP_SUCCESS As Long = 0
> > Private Const SOCKET_ERROR As Long = -1
> > Private Const AF_INET As Long = 2
> >
> > Private Type WSADATA
> > wVersion As Integer
> > wHighVersion As Integer
> > szDescription(0 To WSADescription_Len) As Byte
> > szSystemStatus(0 To WSASYS_Status_Len) As Byte
> > imaxsockets As Integer
> > imaxudp As Integer
> > lpszvenderinfo As Long
> > End Type
> >
> > Private Declare Function WSAStartup Lib "wsock32" _
> > (ByVal VersionReq As Long, _
> > WSADataReturn As WSADATA) As Long
> >
> > Private Declare Function WSACleanup Lib "wsock32" () As Long
> >
> > Private Declare Function inet_addr Lib "wsock32" _
> > (ByVal s As String) As Long
> >
> > Private Declare Function gethostbyaddr Lib "wsock32" _
> > (haddr As Long, _
> > ByVal hnlen As Long, _
> > ByVal addrtype As Long) As Long
> >
> > Private Declare Sub CopyMemory Lib "kernel32" _
> > Alias "RtlMoveMemory" _
> > (xDest As Any, _
> > xSource As Any, _
> > ByVal nbytes As Long)
> >
> > Private Declare Function lstrlen Lib "kernel32" _
> > Alias "lstrlenA" _
> > (lpString As Any) As Long
> >
> >
> >
> > Private Sub Command1_Click()
> >
> > Text2.Text = GetHostNameFromIP(Text1.Text)
> >
> > End Sub
> >
> >
> > Private Function SocketsInitialize() As Boolean
> >
> > Dim WSAD As WSADATA
> >
> > SocketsInitialize = WSAStartup(WS_VERSION_REQD, WSAD) = IP_SUCCESS
> >
> > End Function
> >
> >
> > Private Sub SocketsCleanup()
> >
> > If WSACleanup() <> 0 Then
> > MsgBox "Windows Sockets error occurred in Cleanup.",
> > vbExclamation
> > End If
> >
> > End Sub
> >
> >
> > Private Function GetHostNameFromIP(ByVal sAddress As String) As String
> >
> > Dim ptrHosent As Long
> > Dim hAddress As Long
> > Dim nbytes As Long
> >
> > If SocketsInitialize() Then
> >
> > 'convert string address to long
> > hAddress = inet_addr(sAddress)
> >
> > If hAddress <> SOCKET_ERROR Then
> >
> > 'obtain a pointer to the HOSTENT structure
> > 'that contains the name and address
> > 'corresponding to the given network address.
> > ptrHosent = gethostbyaddr(hAddress, 4, AF_INET)
> >
> > If ptrHosent <> 0 Then
> >
> > 'convert address and
> > 'get resolved hostname
> > CopyMemory ptrHosent, ByVal ptrHosent, 4
> > nbytes = lstrlen(ByVal ptrHosent)
> >
> > If nbytes > 0 Then
> > sAddress = Space$(nbytes)
> > CopyMemory ByVal sAddress, ByVal ptrHosent, nbytes
> > GetHostNameFromIP = sAddress
> > End If
> >
> > Else
> > MsgBox "Call to gethostbyaddr failed."
> > End If 'If ptrHosent
> >
> > SocketsCleanup
> >
> > Else
> > MsgBox "String passed is an invalid IP."
> > End If 'If hAddress
> >
> > Else
> > MsgBox "Sockets failed to initialize."
> > End If 'If SocketsInitialize
> >
> > End Function
> >
> > Sub test()
> > MsgBox (GetHostNameFromIP("192.168.1.30"))
> >
> > End Sub
> >
> >
> > --
> > joel
> > ------------------------------------------------------------------------
> > joel's Profile: 229
> > View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=194661
> >
> > http://www.thecodecage.com/forumz
> >
> > .
> >

  #10  
Old April 11th 10, 09:12 PM posted to microsoft.public.excel.programming
joel[_880_]
external usenet poster
 
Posts: 1
Default IP address to Hostname in Excel


I did a google search so I wasn't suprized that you easily found the
same site. I would think the fix in excel is to change the declarations
of Long to Double. Long would be 32 bits and double would be 64 bits.
Excel 2007 is still in a 32 bit world and the DLL in windows 7 are 64
bit.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=194661

http://www.thecodecage.com/forumz

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Hostname from IP address NickT Excel Worksheet Functions 1 April 9th 10 02:31 PM
How do I avoid excel change absolute address to relative address Miguel Excel Discussion (Misc queries) 3 May 10th 07 11:18 PM
Converting list of IP Addresses to list of Hostname M. Eteum Excel Worksheet Functions 0 March 23rd 06 06:16 PM
Get IP address for a remote computer based on its hostname stabilo Excel Programming 1 February 14th 06 07:08 PM
LINKING Address cells from an EXCEL spreadsheet to fill MapQuest Address Info Duane S. Meyer Excel Programming 0 August 30th 03 12:16 AM


All times are GMT +1. The time now is 04:39 PM.


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