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

Used Car Search

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

No comments:

Post a Comment

Blog Archive