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

Wednesday, April 13, 2011

Scraping BYU Book List

Every beginning of the semester, I would go through my book list and make search to different websites in order to find a lowest price for every book I was required to purchase. This was a very tedious process, copying ISBN number from your book list and then make search to different websites. Not anymore. My VBA project allows a user to upload BYU book list (a saved html page of BYU book list) and it will parse all the ISBN numbers in the book list and make a web search in order to find a lowest price for that particular book. At last it will write all different store prices for all books in the list into an excel file. The program will also allow user to select a destination folder for output excel file. Apart from this my program will allow user to make a single search by Isbn Number.

Files:

http://files.gove.net/shares/files/11w/fishtail/Final_project.xlsm

http://files.gove.net/shares/files/11w/fishtail/Final_project.pdf

http://files.gove.net/shares/files/11w/fishtail/bookListFile.zip

No comments:

Post a Comment

Blog Archive