Office Solutions

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 Send a Notification Email When a Meeting Reminder Alerts You in Outlook

Do you want to send a notification email before a meeting in Outlook? This article will teach you how to use Outlook VBA to auto send such an email to the meeting attendees when its reminder alerts you. Sometimes, so as to ensure that the required attendees can attend the meeting on time, you may desire to send a notification email to them. It aims to prevent them from forgetting the meeting. However, sending such an email manually may be a bit time-consuming as you have to determine the...

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 »