Here is a way to get the IP address of your computer. This was originally reported at
http://stackoverflow.com/questions/828496/how-to-retrieve-this-computers-ip-address
Make sure that you have the required reference (WMI Scripting) selected under Tools, References in the VBE as shown in the figure below.
Copy/paste the following code to a general module in the VBE and then type =GetIPAddress() into a worksheet cell (or, use it in a VBA procedure).
Function GetIPAddress()
Const strComputer As String = “.” ‘ Computer name. Dot means local computer
Dim objWMIService, IPConfigSet, IPConfig, IPAddress, i
Dim strIPAddress As String
‘ Connect to the WMI service
Set objWMIService = GetObject(“winmgmts:” _
& “{impersonationLevel=impersonate}!\\” & strComputer & “\root\cimv2”)
‘ Get all TCP/IP-enabled network adapters
Set IPConfigSet = objWMIService.ExecQuery _
(“Select * from Win32_NetworkAdapterConfiguration Where IPEnabled=TRUE”)
‘ Get all IP addresses associated with these adapters
For Each IPConfig In IPConfigSet
IPAddress = IPConfig.IPAddress
If Not IsNull(IPAddress) Then
strIPAddress = strIPAddress & Join(IPAddress, “, “)
End If
Next
GetIPAddress = strIPAddress
End Function
HTH!
Pingback: #Excel Super Links #31 – shared by David Hager | Excel For You
Pingback: # Excel Super Links #72 – shared by David Hager | Excel For You
Pingback: #Excel Super Links #90 (Special Edition) – shared by David Hager | Excel For You
Pingback: #Excel Super Links #150 – Special Edition | Excel For You