Executive Summary
My projects allow users to search KSL’s classifieds web site using specified search criteria and receive those results through email or text message. It is designed to run by itself at designated intervals, relieving the user of the task of frequently checking manually for new posts.
I designed my project to assist my brother in his side business. He lives in Sandy and has a full-time job as a salesman at a building supply company. However, he also puts in a considerable amount of time on the side buying and selling items on KSL. Some of the jobs are simple flipping, but more often he does some work to the product to add value to it before reselling. For example, he’ll buy trailers that need welding and painting work, do it himself, and then resell them. In addition to trailers, he concentrates in Toyota parts, Bobcat equipment, and various metal scrap.
Though the projects have been profitable for him, he faces competition. A lot of the classified postings on KSL are overpriced, without much potential for resale profit. The postings that have profit potential tend to sell quickly, so it is important to be one of the first people to see the post. The difficult thing for my brother is that he works full-time, so he can’t spend all day checking for updated postings. Ideally, he would like to have a program that notifies him when new postings are listed, without him taking the time to log in and check manually. He wants to be able to specify the search criteria, and have searches running all day while he is at work. When matches are found, he would like an email to be sent with the ad title, price, and a link to the ad itself. This would help him get more of the good deals, and would reduce the amount of time he has to spend searching. Wanting to help out, I agreed to automate the project using VBA.
http://files.gove.net/shares/files/12w/jeshuabw/KSL_Final_Project_Complete.xlsm
http://files.gove.net/shares/files/12w/jeshuabw/VBA_Write-Up.pdf
No comments:
Post a Comment