Use VBA to capture IP address

[KR]

I did a google search for both old posts, and Excel FAQs, but wasn't able to
find what I am looking for...

Does anyone have a snippet on how to use Excel VBA to grab the current
machine's IP address?

I figure it would be something like Randy Birch's code to grab the currently
logged in user's UserID, but his code is more advanced than I can manage, so
at this point I figure I'm stuck panhandling for a sample for the IP
address.

Thanks in advance,
Keith

 

[Jan Karel Pieterse]

Hi Kr,

Does anyone have a snippet on how to use Excel VBA to grab the current
machine's IP address?

This post seems relevant:

http://groups-beta.google.com/group/microsoft.public.access.forms/browse
_thread/thread/e53de926fe624b6a/1792994120ef6681?q=vba+API+get+ip+addres
s+of+machine&_done=%2Fgroups%3Fsourceid%3Dnavclient%26ie%3DUTF-8%26rls%3
DGGLD,GGLD:2003-44,GGLD:en%26q%3Dvba+API+get+ip+address+of+machine%26&_d
oneTitle=Back+to+Search&&d#1792994120ef6681

(all one url)

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

 

[Jason Morin]

Try:

http://puremis.net/excel/code/079.shtml

HTH
Jason
Atlanta, GA