Use VBA to capture IP address

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

--
The enclosed questions or comments are entirely mine and don't represent the
thoughts, views, or policy of my employer. Any errors or omissions are my
own.

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/...s.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

Try:

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

HTH
Jason
Atlanta, GA

>-----Original Message-----
>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
>
>--
>The enclosed questions or comments are entirely mine and
don't represent the
>thoughts, views, or policy of my employer. Any errors or
omissions are my
>own.
>
>
>.
>