I am FULLY CONFIDENT of completing the scraping Excel VBA code for Wines and without using any 3rd-party libraries apart from those which are part of Windows OS. We can use WinHTTP for retrieving web pages. We can also use XMLHTTP, but WinHTTP is faster and has additional features like proxy support.
QUESTIONS
• Can you provide the URLs of websites for which data scraping needs to be done?
• Is logging into website(s) required before scrape?
RETRIEVING HTML AND PARSING INFORMATION
We will use XMLHTTP/WinHTTP library to retrieve the webpage silently, i.e. without displaying anything to user. If the webpage employs complex AJAX to display results or if the webpage requires JavaScript engine to display results, we will use WebBrowser control embedded in a UserForm.
We will use DHTML or DOM to Access different components of web page. This is the best way as we have individual objects and collections for various HTML Elements such as table, tr, td, a, etc. So, we can directly retrieve contents of a particular cell or we can retrieve href for a link and so on. Down to "atomic" level we will parse information in cell or other using Regular Expressions.
Oh! All above libraries are part and parcel of Windows OS and are already installed on your computer. In fact, they are freely available from Microsoft.
I HAVE EXPERIENCE
Although new to Freelancer.com, I have extensive experience in Excel VBA, DOM, WinHTTP, XMLHTTP, Regular Expressions, and related web scraping technologies.