Executive Summary:

Generally, business executives do a substantial amount of travelling. However, I’ve noticed that many of them do not plan their own travel but instead, have their secretaries do it for them. Although there is nothing wrong with this, secretaries then are left with the burden of planning a trip or several trips within a short period of time. In my own life I have also noticed how time consuming trip-planning can be. For this reason, I have created a macro to help provide a brief overview of the costs of travelling.

My project focuses on two main sources of travel, driving and flying. The user can enter his data and know exactly how much a trip will cost and how long a trip will take. As was mentioned in my proposal, the information will return the price of the flight and pull the cheapest flight. Additionally, the overall cost of driving will be calculated and compared to the flight price and whichever is less expensive will be shown in a message box. The project consists of a simple userform in which users can enter all of their relevant information and then easily select a button to pull in the information from several web sources. The final product is a basic table with the pulled data and is simple enough for anyone to understand. In addition to the table, users can also request an email, by clicking another button, with the link associated to the flight information gathered from the web. From this email they can immediately go to the website and purchase plane tickets to their destination.

• Travel Costs Write-up
• Travel Costs Excel Document