What is my Public IP Address? There are no direct methods to get public ip address in VBA. This has to be done by using a web service using below steps: Open IE Explorer from VBA Code. Navigate to this page -> What is my Ip? Wait for page to […]
Find Local IP Address – VBA Macro Code
December 22, 2024
Computer IP Address – Local & Public IP stand for Internet Protocol address. It is assigned to every network device – be in a computer, smartphone, router etc., This address is used to send the Internet data packets to the correct device attached to internet. The IP address have different […]
Excel VBA Hyperlink Follow – URL within Macro
December 22, 2024
How to Click Hyperlink in Excel with VBA Macro? There are 2 methods available to click a hyperlink in Excel. Both the methods do open the URL in the default browser or open the corresponding file in the default application. Here is the code demonstrates both methods. Sub follow_hyperlink() ‘Follow […]
How to get Computer MAC Address using Excel VBA?
December 22, 2024
Get VBA Code to find the MAC address for a computer. This VBA code will list the MAC Address of all the network adapters installed in your computer.
List all Network Adapter, MAC , Enable Disable Connection using VBA
List all Network adapters in a computer using Excel VBA. Get MAC address, Connection status, Name etc., Disable, Enable, On/OFF any Network adapter.
VBA – Check for Active Internet Connection – Network Status
Get VBA Code to check if the Internet connection is active. This code uses Windows API function to get the Computer’s Network connection status.