Searching for a used car on many different websites can be a hassle, especially if you know exactly what kind of car you are looking for along with the year, price, mileage, etc. because you have to constantly input these items into the search option. It’s also an annoyance to have to go to each and every website and check if the new postings fit your criteria.
To alleviate these hassles, I wrote a program where the user inputs information into the user form and then the user form takes what was entered and searches it on ksl.com. Once the search is complete, the price, year, and mileage, along with a link to a picture of the car and a link to the ad is posted on the spreadsheet. The user can then sort the data based on price, mileage, or year. This allows the user to easily access cars that meet their criteria without having to enter in all the information themselves.
http://files.gove.net/shares/files/10f/gb228/final_project_writeup.pdf
http://files.gove.net/shares/files/10f/gb228/final_project.xlsm
These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience
Thursday, December 9, 2010
Subscribe to:
Post Comments (Atom)
Blog Archive
-
▼
2010
(150)
-
▼
December
(76)
- Automated Web Stats Collection
- Add A Class
- <!--[if gte mso 9]> <![endif]--><!--[if ...
- End-of-Semester Reconciliation
- Discounted Cash Flow Model
- Classified Ads Deal Finder
- BYU Auto-Registration Program
- Analytic Hierarchy Automated Decision Making Process
- Rotation Recommendation
- Mutual Fund Assistance Model
- YSA Tracking Program
- Investment Analysis Calculator
- Comparable Company Analysis and the WACC
- Used Car Search
- Your Financial Dashboard
- Sales Batch Auditor
- Bloomberg Report Via Excel Userform
- Cougar Scheduler
- <!--[if gte mso 9]> <![endif]--><!--[if gte...
- VIN Decoder
- Financial Statement Ratio Builder
- Food Storage Tracker
- Financial Planner/Projector by Derek Parker
- Bookkeeping in Excel
- Football, Fast and Easy
- 360 Feedback Splitter
- Mutual Fund Manager
- Family Finance Application
- Competition Information
- Cell Phone Bill Calculator
- Creating Forward-Looking Personal Account Budgets ...
- Batch File System
- Buy and Sell Stocks
- Job Application Automator - Chris Fisher
- C-Clearly Customer Database
- CRE loans Autoformatter
- Employee Payroll Userform
- Benjamin Olson, Bank Access and Bill Pay
- The Olive Garden Scheduler!
- What a happy day when a bright-eyed college senior...
- REIC Membership Batch Report
- REIC Purchase Order
- Excel Scrabble
- Independent Film Distribution
- Pandora Playlist Creator
- Around the World: Cheapest Flights for Flexible D...
- EQProgram: Automating the Ministry
- The Food Storage Inventory Manager
- Downloading & Formating from Intrade
- Visual Sales Reports_Christian Jones
- Brian Wade - Final Project - PinsRUS Pricing and Q...
- Get me to the airport on time
- Stock Evaluator
- Personal Budget, Jeff Woodland
- Mint Analytics, Nathan Allred
- EFTPS Time Saver by Devin Davidson
- <!--[if gte mso 9]> Normal 0 f...
- Pick Me! The Application Selection Process Assista...
- Flash Card Machine, Brian Baugh
- Stock Performance Indices, Tommy Smith
- ArticleMaker by Dave Brown
- Survey Generator
- Expense Recorder & Analyzer
- Recurring Revenue Report - Steven Wilde
- Matt Blodgett VBA Project - Nibbles Game
- Executive Summary: Genealogy Worksheet
- Gathering Credit Card Data
- NPV calculation
- Executive Summary - Brent Ray
- Moneytrackin Expense Reports
- Executive Summary - Accounting Comission Automation
- UVFA Inventory Project
- Executive Summary: Health and Fitness Application
- Executive Summary: Rental Property Reconciliation
- Executive Summary: Stock Picker
- Executive Summary: Invoice Tracker
-
▼
December
(76)
No comments:
Post a Comment