Excel: Best way to web scrape using excel as database

Does anyone have a recommended way to scrape data off the web and get it to populate into an excel document? For example, I am going through a hotel site and I'd like to scrape all the different hotel room rates for that particular hotel location and store it in an excel document. I'd like to be able to re-run this (macro or code) weekly and see the different rates? I'm manually doing it and putting it into excel but there must be a better way.

This question generated 30 answers. To proceed to the answers, click here.

This thread is current as of March 18, 2014.

For more resources for Microsoft Excel