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%3Dnavclien t%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.


.