How to Create a Geographic Tool to Get Latitude and Longitude Coordinates for Addresses with Excel VBA

Follow this article and build your own geographic tool with which you can get the latitude and longitude coordinates for an address.  Converters like this are commonly used by Real estate brokers. Download Now If you want to start to use the software as soon as possible, then you can: Download the Software Now Otherwise, if you want to DIY, you can read the contents below. Let's prepare the GUI All you need is a single Excel sheet and you can name the sheet as per your need. In this...

Read more »

How to Auto Identify SQL Server Operator and Add It to Job Notification

Monitoring the status of SQL server jobs is very important. If there is corrupted SQL Server agent, then jobs would not run as scheduled. So make sure you repair corrupted SQL Server before proceeding. Auto identifying operator and adding it to job notification on hundreds of servers is a hectic task. However with this script you can easily monitor all your SQL server jobs. Set operators SQL Server operators allow people or groups to receive notifications when jobs complete on SQL server or...

Read more »

How to Create Your Own Expense Manager via Excel VBA

This article will help you to create simple and easy to use Expense manager. Now you can log and track all your incomes, expenses and keep a track of your balances. Download Now If you want to start to use the software as soon as possible, then you can: Download the Software Now Otherwise, if you want to DIY, you can read the contents below. Let's prepare the GUI Open a new workbook and save it as macro enabled excel file. We just need two sheets in the workbook. So delete extra...

Read more »