Get code to Extract data from website using vbscript. Also the code can be used to parse the html data obtained from the website using vbs parser.
Extract Web Page with Table to your PC with just Excel. This code can also be used a Best Data Mining Tool.
When Web query did not work, Use the option explained in this article to import Web page Table with just Excel VBA and process the Tags as explained in this quick reference Tutorial.