Returning IP address using the Shell command - Please Help!

[gargs]

How can I get the following code to capture the IP address of a URL and put it in a variable? It performs the traceroute command ok but the IP variable only captures the ping time.

Private Sub CommandButton1_Click()
Dim Ip
For Each x In Range("A3:A3&quot
Ip = Shell("tracert x, 1&quot 'Run Traceroute Command
Range("A3:A3&quot = Ip
Next
End Sub

Any suggestions would be much appreciated. Thanks in advance....

 

[ide]

i'm sorry, it will be a little bit long...
i've found a code. if you are not so keen on dos shell and the tracert;

You can get your ip like:
Sub callFinder()
MsgBox FindHost("

http://www.yahoo.com")

MsgBox FindHost("

http://www.allapi.net")

MsgBox FindHost("

http://www.altavista.com")

End Sub

after creating a module and inserting the following code:

' #VBIDEUtils#***********************************************************************
' * Programmer Name : Waty Thierry
' * Web Site :

http://www.geocities.com/ResearchTriangle/6311/

' * E-Mail : waty.thierry@usa.net
' * Date : 13/10/98
' * Time : 10:24
' * Module Name : IP_Module
' * Module Filename : IP.bas
' *********************************************************************************
' * Comments :
' * Find IP address ginving the hostname
' **********************************************************************

'Here's sample code for gethostbyname()

'Add a textbox (Text1) And a Command button (Command1) To a New form And use the following code:

'Usage: Fill in the textbox with the name you want to resolve and click the command button to resolve the name.

Private Const WS_VERSION_REQD = &H101
Private Const WS_VERSION_MAJOR = WS_VERSION_REQD \ &H100 And &HFF&
Private Const WS_VERSION_MINOR = WS_VERSION_REQD And &HFF&
Private Const MIN_SOCKETS_REQD = 1
Private Const SOCKET_ERROR = -1
Private Const WSADescription_Len = 256
Private Const WSASYS_Status_Len = 128

Private Type HOSTENT
hName As Long
hAliases As Long
hAddrType As Integer
hLength As Integer
hAddrList As Long
End Type

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
iMaxUdpDg As Integer
lpszVendorInfo As Long
End Type

Private Declare Function WSAGetLastError Lib "WSOCK32.DLL" () As Long
Private Declare Function WSAStartup Lib "WSOCK32.DLL" (ByVal wVersionRequired&, lpWSAData As WSADATA) As Long
Private Declare Function WSACleanup Lib "WSOCK32.DLL" () As Long
Private Declare Function gethostbyname Lib "WSOCK32.DLL" (ByVal hostname$) As Long
Private Declare Sub RtlMoveMemory Lib "KERNEL32" (hpvDest As Any, ByVal hpvSource&, ByVal cbCopy&)


' #VBIDEUtils#************************************************************
' * Programmer Name : Waty Thierry
' * Web Site :

http://www.geocities.com/ResearchTriangle/6311/

' * E-Mail : waty.thierry@usa.net
' * Date : 13/10/98
' * Time : 10:24
' * Module Name : IP_Module
' * Module Filename : IP.bas
' **********************************************************************
' * Comments :
' * Find IP address ginving the hostname
' **********************************************************************

Function hibyte(ByVal wParam As Integer)

hibyte = wParam \ &H100 And &HFF&

End Function

Function lobyte(ByVal wParam As Integer)

lobyte = wParam And &HFF&

End Function

Sub SocketsInitialize()

Dim WSAD As WSADATA
Dim iReturn As Integer
Dim sLowByte As String, sHighByte As String, sMsg As String

iReturn = WSAStartup(WS_VERSION_REQD, WSAD)

If iReturn <> 0 Then
MsgBox &quot;Winsock.dll is not responding.&quot;
End
End If

If lobyte(WSAD.wversion) < WS_VERSION_MAJOR Or (lobyte(WSAD.wversion) = WS_VERSION_MAJOR And hibyte(WSAD.wversion) < WS_VERSION_MINOR) Then
sHighByte = Trim$(Str$(hibyte(WSAD.wversion)))
sLowByte = Trim$(Str$(lobyte(WSAD.wversion)))
sMsg = &quot;Windows Sockets version &quot; & sLowByte & &quot;.&quot; & sHighByte
sMsg = sMsg & &quot; is not supported by winsock.dll &quot;
MsgBox sMsg
End
End If

If WSAD.iMaxSockets < MIN_SOCKETS_REQD Then
sMsg = &quot;This application requires a minimum of &quot;
sMsg = sMsg & Trim$(Str$(MIN_SOCKETS_REQD)) & &quot; supported sockets.&quot;
MsgBox sMsg
End
End If

End Sub

Sub SocketsCleanup()
Dim lReturn As Long

lReturn = WSACleanup()

If lReturn <> 0 Then
MsgBox &quot;Socket error &quot; & Trim$(Str$(lReturn)) & &quot; occurred in Cleanup &quot;
End
End If

End Sub

'Sub Form_Load()
'
' SocketsInitialize

'End Sub

'Private Sub Form_Unload(Cancel As Integer)

' SocketsCleanup

'End Sub

Public Function FindHost(myHst As String) As String
SocketsInitialize
Dim hostent_addr As Long
Dim host As HOSTENT
Dim hostip_addr As Long
Dim temp_ip_address() As Byte
Dim i As Integer
Dim ip_address As String

hostent_addr = gethostbyname(myHst)

If hostent_addr = 0 Then
MsgBox &quot;Can't resolve name.&quot;
Exit Function
End If

RtlMoveMemory host, hostent_addr, LenB(host)
RtlMoveMemory hostip_addr, host.hAddrList, 4

ReDim temp_ip_address(1 To host.hLength)
RtlMoveMemory temp_ip_address(1), hostip_addr, host.hLength

For i = 1 To host.hLength
ip_address = ip_address & temp_ip_address(i) & &quot;.&quot;
Next
ip_address = Mid$(ip_address, 1, Len(ip_address) - 1)

FindHost = ip_address
SocketsCleanup
End Function

 

[jonscott8]

FWIW, the IP variable is NOT capturing the ping response time as per your initial comment. It's capturing the Process ID of the command emulator that's executing the tracert program.

I'm not sure exactly what your are attempting to do, so I'm not sure what to recommend. But if you must use the tracert program, the only way I see you being able to obtain that info is to send the output to a text file, the parse that text file for the IP addresses, which is going to be hairy. Jon Hawkins