How to get IP address with Excel VBA code using WMI


To totally unlock this section you need to Log-in


Login

Question

What is the least cumbersome (module-inclusion, code lenght, etc.) way to retrieve the machine IP address (of the first interface open)?

Answer

It requires that you have Microsoft WMI Scripting Library in the project's references. You will use that using, in a cell, the formula =GetIPAddress().


To totally unlock this section you need to Log-in


Login

1 thought on “How to get IP address with Excel VBA code using WMI”

Comments are closed.