Hi, sometimes we need to update the excel workbook to update on load or when someone press button to update. But if there is no internet connection it might throw error or exception. To avoid exception and error we can check the internet connection using vba. Please find below code to determine… read more →
Hello friends, I was working with excel programming. It was my first project in excel programming so I was very excited. I was already familiar with visual basic but didn’t developed any application using VBA. My VBA application wasn’t much complex. Actually I have to get data from a web api and… read more →
For security reasons we need to retrieve the mac address of system. MAC addresses are 12-digit hexadecimal numbers written in format MM:MM:MM:SS:SS:SS We can retrieve the mac address using various ways, but I am going to explain how do we get the mac address using excel vba. Its not a very difficult… read more →