Export HTML table to Excel VBA. 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.