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

Tuesday, April 15, 2014

Spend My Cents - Excel Edition - Mack Cope

About a year ago a friend and I created www.spendmycents.com, a reverse product search that searches amazon based on price. A picture of the website is below. 




I struggled a bit about what to do for this final project. So I decided to recreate some of the functionality of this web app in Excel. There really isn’t really a business need for this, but nevertheless it was an opportunity to display some of the things I learned in this class. To recreate some of the functionality of the web app I started with a user form to allow a user to search for products in different categories based on a desired price. When a user clicks search it takes the information they entered and queries our api, which talks to amazon and finds products that are available in that category and at that price. As the results are received, I download the images associated with the products. Once the product information is all downloaded, a user form pops up that allows a user to navigate through each product, with the option to view it on amazon’s we page, or save the information for later.

Project Files: http://files.gove.net/shares/files/14w/mcope/Mack_Cope_Final_Project_VBA.zip

Project Paper: http://files.gove.net/shares/files/14w/mcope/Mack-Cope-VBA-FinalProject.pdf

1 comment:

Blog Archive