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

Friday, April 13, 2012

Your Personal San Francisco Craigslist Search

This project was intended to make housing searches on Craigslist more efficient. It was created for personal use only and has no business advantage. The motivation behind the project was an imminent move to San Francisco. I will be moving one week after graduating from the MBA program, and have a very busy course load of 19.5 credits. The housing market in San Francisco is competitive and requires a large time commitment to online searching, almost all of which is done on Craigslist. My intention was to automate the craigslist search process in San Francisco and thereby save myself a lot of time doing repeat searches. My VBA program is intended to allow the user to enter search criteria from an independent user form in Excel. The program will then collect the data from the user, plug the data into the appropriate fields in the craigslist online search, and then deliver the search results into an Excel spreadsheet. The user (myself) would then be able to view the results of the query loaded into one place, and organized into categories of 1) listing date 2) price 3) bedrooms 4) the link to the posting. If the listing is of interest to the user, they can then click on the link to view any images connected to the posting, and from there contact the lister.

No comments:

Post a Comment

Blog Archive