Web Scraping Projects
This
section describes Web Scraping projects I have written in Excel/VBA.
Business_List.xls: Creates
a company mailing list from a business directory.
CareerBuilder.xls: Updates
a job list from CareerBuilder.com, color-coding new, active, dropped and
reposted jobs.
Dice.xls: Updates
a job list from Dice.com, color-coding new, active, dropped and reposted jobs.
Exchange_Rate.xls: Updates
and graphs exchange rates by date.
States.xls: Creates
a list of states, retrieving Admission Date, 2009 Population,
Stocks.xls: Updates
and graphs a particular stock by date.
Thesaurus.xls: Creates
a list of synonyms for a given word.
Top_10_Songs: Updates
a Top Ten songs list.
Top_20_Cars.xls: Updates
Top 20 car popularity list.
Weather.xls: Updates
and graphs a weather list, retrieving Temperature, Humidity, Dew Point,
Visibility, UV Index, Sunrise, Sunset, etc.
Zip_Code_Info.xls: Creates
a list of zip code information for the specified zip code.
Zip_Code_Radius.xls: Creates
a list of all zip codes within