- you have data stored in Excel sheets and you want to push data into online web forms.
- you need to extract data from web and save them into Excel xls file.
- automate Internet Explorer browser from Excel VBA macro.
- automate both IE and Excel from an external process using OLE automation.
The WSH web macro in this tutorial opens an XLS file containing phrases to be translated using Google Translate tool. It then automatically gets each phrase, opens an IE browser, navigates to translation page, fills out the text to be translated, press submit button, gets back the result and saves it into the same XLS file.
That's all for now! (as I try to keep articles relatively short) Meanwhile, you should download Twebst Automation Studio and the web macro sample to see it at work. Then, you can continue with the next article explaining the web macro code and comments: Extract web data into Excel.Application with browser macro
Twebst Automation Studio (FREE edition available btw)