How do I determine my computers IP address through VBA in Excel

[valhalla]

Afternoon,

I am trying to find a function that I can use through Excel, with or without VBA (I'm assuming that I will need VBA) that will return the computer's current IP address. For the application that we are developing, the IP address may or may not be dynamic (some users on dial-up, others on LANs) so we need to be able to determine the IP in-session and work with it. Does anyone know how to accomplish this?

Thanks in Advance,
Brian

Brian Lewis
The Aerospace Corporation

http://www.aero.org/

 

[IFRs]

If all else fails, you can use VBA to open a command window to run IPCONFIG > IP.txt, then open IP.txt and siehter go to the 8th line or search for the string "IP Address" and then select the text that follows the colon and space.

I hope you get a better answer than mine...