Wired Equivalent Privacy (WEP) WEP is a security algorithm for IEEE 802.11 wireless networks. It was introduced with the original 802.11 standards ratified in 1997, and it was majorly done to provide data confidentiality which was not in traditional wired networks. WEP is recognizable by its key of 10 or 26 hexadecimal digits (40 or 104 bits). It was of […]
Honeypot : Trap for Hackers
December 21, 2024
What is a Honeypot? A honeypot is a system that is network-attached and is deployed as a decoy to lure cyber attackers and to find, change or study hacking procedures or attempts in order to gain unauthorized access to information systems. The function of a honeypot is to represent itself […]
Overview of Data Communications and Networking
December 21, 2024
Introduction The development of personal computers brought about tremendous changes in business, industries, science & education. Business today relies on computer networks and the internet. Mails, documents, files are reached to our computers almost instantaneously from any part of the world. Exchange of Data between two devices via some form […]
VBA Get My Public IP Address
December 21, 2024
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 […]
What is my IP Address?
December 21, 2024
[show_ip] This page displays the public IP address assigned to your computer. This shows the IPV4 address. To view IPV6, open command prompt & use the command ipconfig. Along with IPV6 public IP address, this command will display even the local IP address if your computer is connected to internet […]
Find Local IP Address – VBA Macro Code
December 21, 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 21, 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 […]
Vba Get Computer Name using environment variable
December 21, 2024
Find Computer Name in Excel VBA In this page, get three different vba code to get Computer name. Environment variable Windows Api wScript.Network To get the computer name or the host name there can be more multiple ways. But, one of these could serve the purpose. 1. Get Computer name […]
List available Wifi Networks & change Connection
December 21, 2024
Get cmd prompt command to list available networks in your computer wifi connection. Also get command to change to any of the preferred wifi networks of your choice.
How to Web Scrape with VBA using IE & Parse HTML?
Get VBA code to web scrape using IE & then parse HTML data from website. The extracted website data is Parsed within Excel VBA code itself.