This short tutorial is about automating
Internet Explorer browser from an
Excel VBA macro using
Open Twebst, an open source IE automation framework.
- download and install Open Twebst from: http://codecentrix.com/download.html
- start recording your web actions and choose VBA code generator
- open Excel, create an workbook and insert a new macro: View/Macros/View Macros => fill out a Macro name + Create
- copy the VBA code from Twebst recorder window and paste it into VBA macro editor
- add reference to Open Twebst library from Excel VBA macro editor: Tools/References => Open Twebst 1.0 Type Library
- save the workbook; choose Excel Macro-Enabled Workbook (*.xslm) type in Save dialog box
Here is the whole story in pictures:
2 comments:
Many thanks...adrian..very useful tool.
can u plse share ,is there any alternative way to use the code in excel without using twebst library...
Thanks in Advance.
prakash.k
Hi,
Twebst library includes quite a lot of functionality which can be hard or even impossible to implemented only with VBA/Excel.
However Open Twebst is open source so one can always try to translate the functionality from C++ to VBA.
Regards,
Adrian.
Post a Comment