excel macro code for vp and ip address

[FrancArth]

Hi, I'd like to know if there's a simple code for getting the vpn and ip address of a computer. Thanks.

I already have the code for the username - I'm missing getting vpn and ip address or where the computer connects to the internet.

 

[shg]

Cross-posted at vb code to get vpn and ip address

 

[Worf]

As the OP is new, at least here:

Rule #13:
We prefer that members do not cross-post questions to other forums, but when this does occur members should do the following:
- Post the details of your question on our forum. Do NOT simply post a link/re-direct to the question in another forum with no details posted here.
- Make it clear that you have cross-posted and provide links to the cross-posts.
Cross-posted questions that do not comply may be deleted or locked. For a discussion on the issues with cross-posting, see this link: Excelguru Help Site - A message to forum cross posters

 

[FrancArth]

I'm so sorry for this - it won't happen again.

How do I delete this? Sorry again.

 

[Worf]

I don't think you can delete your post after ten minutes or so.

I'm not a moderator here, but in my opinion, being a rookie, you are excused.

 

[Worf]

See if this helps: Get Public IP, Local IP & MAC Address Using VBA ~ My Engineering World

 

[FrancArth]

Hi Worf, thanks for all the help. I really appreciate it. I'll be closing this thread and will be using the other one in the excelforum site to avoid cross-posting.

Thanks again for all the help.