Networking Tips
How Can I Get Network Information for the Current User?
The example below demonstrates how to retrieves the username, logon server name and logon domain name for the currently logged in user, as well as a list of all global groups that user belongs to.
The Network Information example requires the use of Windows API calls. The zip file download contains two versions of this example, one that supports Excel 2003 and earlier (32-bit only) and one that supports Excel 2007 and later (32-bit and 64-bit).
How Can I Get the IP Address of the Current Computer?
This example showing how to retrieving the IP address(es) for a computer requires a complex series of Windows API calls. However, it is one of the few network-related utilities that operates on all versions of Windows from 95 onward. It's not something you'll need very often, but when you need it you really need it.
The Get IP Address example requires the use of Windows API calls. The zip file download contains two versions of this example, one that supports Excel 2003 and earlier (32-bit only) and one that supports Excel 2007 and later (32-bit and 64-bit).
How Can I Test Network Connectivity for the Current Computer?
If your application requires a connection to a local network or an external web URL, you should test whether this connection can be made before you attempt to run any code that depends on it. The example below shows how to test whether the current computer is connected to a local network as well as whether the current computer can connect to a specific web URL.
The Network Connection Tests example requires the use of Windows API calls. The zip file download contains two versions of this example, one that supports Excel 2003 and earlier (32-bit only) and one that supports Excel 2007 and later (32-bit and 64-bit).