Get VPN or Internet Access as a MsgBox - Excel Macro Code

I'm not clear what you want to achieve here. Could you elaborate more on what the purpose is exactly?

 Sub ShowMeDetails ()

MsgBox Environ("COMPUTERNAME")
MsgBox Environ("USERPROFILE")
MsgBox Environ("USERDOMAIN")

End Sub 

Select allOpen in new window

I need to show as a MsgBox where the user has logged to (see picture, sample MsgBox ("VPN"=group.net).

And what if connected with LAN, WiFi and VPN? What to choose to display? And what is the purpose - or, how does it matter at all?

And what if connected with LAN, WiFi and VPN? yes, if needed. All I need is to get where the user is connected (eg: group.net and would should as a MsgBox)

What to choose to display? just a MsgBox

And what is the purpose - or, how does it matter at all? we are checking how many users are using the VPN, connected at school, at home, or in the office.

Sub ShowMeDetails ()

MsgBox Environ("COMPUTERNAME")
MsgBox Environ("USERPROFILE")
MsgBox Environ("USERDOMAIN")
MsgBox ("VPN = Internet Access") 'I need this code to run my file

End Sub

Select allOpen in new window

is this MS Excel VBA Macro?

No, it is a cmd.exe batch file (.cmd or .bat).

Aww. I appreciate your efforts. But I would need something Excel macro related language. :(

You know your way to output stuff results in "endless" message boxes popping up each with a single information? Not user-friendly ...
We certainly can provide code to generate the batch file, run it, and display the results from VBA, but I'm not sure you should want to do that ...

I'll try that one if it's ok? hopefully that would complete this file.

up :(

Idea in ipconfig, parsing in vba