Open source web testing and automation framework

10, 9, 8 ... ignition sequence start ...
3, 2, 1, zero ... All engines running. Lift-off! We have a lift-off.




I am happy to announce Open Twebst, open source web testing and automation framework!

http://open-twebst.codecentrix.com/

Get it while it's hot!

Happy web automation to y'all!

IE9 Automation and Web Macros

Twebst Automation Studio 2.6 - New Release!

I am once again happy to announce a new version of Twebst Automation Studio. What's new:

• IE9 web automation and macro support.
• custom DLL injection instead of BHO browser extension (which in IE9 generates security warnings).
• TwebstBHOps.dll is no longer needed.
• FindBrowser and FindAllBrowsers now work with any application that embeds Internet Explorer web control.
• Bug fixes and enhancements.

Download Twebst 2.6

.

IE8 close tab programmatically

Sometimes you may wish to close a browser instance and Twebst Library has support for that. You just have to call Close method against the Browser web automation object you want to close.

Let's see a short JScript web automation macro that closes the first IE8 tab loaded from google.com domain. If the closing tab is the last tab inside the IE frame then the whole browser will be closed.

// Create core object.
var core = new ActiveXObject("Twebst.Core");

// Find a browser for which the displayed URL contains "google.com".
core.useRegExp = true;
var b = core.FindBrowser("url=.*google.com");
b.Close();

There are more Twebst methods for automating IE7 and IE8 tabs that I'll talk about in future articles: OpenNewTab, activeTab, isTabActive, tabList

Twebst Automation Studio 2.5 - New Release!

This blog was too quiet for some time but after another development cycle I am happy to announce a new release: Twebst Automation Studio version 2.5

New features:

• ClosePopup web automation method
• ClosePrompt web automation method
• closeBrowserPopups web automation property
• OpenNewTab web automation method
• tabList web automation property
• activeTab web automation property
• isTabActive web automation property
• asyncHtmlEvents web automation property
• RightClick support added in web recorder
• index attribute added to FindFrame method
• minor bug fixes in web automation library, web recorder and help system

.

Download Twebst - IE Automation Software

Move data from Excel to IE and back with VBA web macros

Let's continue my previous post (IE8 Automation using Excel VBA Macro) with some VBA Internet Explorer automation code:

' Don't forget to add reference to TwebstLib from menu Tools/References
Dim core As TwebstLib.ICoreVba
Set core = New TwebstLib.core

Dim browser As TwebstLib.IBrowserVba
Set browser = core.StartBrowserVba("http://www.google.com/")

For i = 1 To 5
   ' Get the current text to be translated
   Dim textToTranslate As String
   textToTranslate = ActiveSheet.Cells(i, 1).Formula

   ' Twebst web automation part
   Call browser.Navigate("http://www.google.com/language_tools?hl=en")
   Call browser.FindElementVba("textarea", "id=source").InputText(textToTranslate)
   Call browser.FindElementVba("select", "name=sl").Select("English")
   Call browser.FindElementVba("select", "name=tl").Select("French")
   Call browser.FindElementVba("input submit", "text=Translate").Click

   ' Find result span object
   Dim resultObj As TwebstLib.IElementVba
   Set resultObj = browser.FindElementVba("span", "id=result_box")

   ' Get the text result
   Dim translatedText As String
   translatedText = resultObj.Text

   ' Save the result into Excel sheet
   ActiveSheet.Cells(i, 2).Formula = translatedText
Next

Points of interest:

• in VBA web macro new methods are used (see FindElementVba). The newly added methods (from version 2.1) are especially designed for VBA language and they work the same as they non-VBA counterparts except the fact no variable number of search conditions are supported.
• Twebst web recorder was updated to automatically generate VBA macro code against the newly added methods.
• all web page loading synchronization is provided by default by the library.
• when automating web controls all necessary HTML events are fired up against target object (see fireEvent) to simulate user's web action.
  

Downloads:

• Twebst Automation Studio PRO you'll need this installed before running the sample VBA macro
• TwebstVBA.zip containing sample Excel and BAS files.

IE8 Automation using Excel VBA Macro

In my previous posts (Excel and IE automation - the WSH way, Extract web data into Excel.Application with browser macro) I automated both IE and Excel using WSH. Now I'm going to automate Internet Explorer directly from an Excel macro using the VBA language.

The VBA macro will work against a sheet containing phrases to be translated using Google Translate tool. It automatically gets each phrase, opens IE browser, navigates to translation page, waits the web page to complete loading, fills out the text to be translated into HTML web controls, press submit button, gets back the result and saves it into the same Excel sheet.

It is possible to directly automate IE browser from VBA macro but it is not always as simple as it should be. (see my older post: What's wrong with Internet Explorer Automation?) Using Twebst Automation Studio when automating IE from VBA has some advangates:

• it works with all Internet Explorer versions: IE6, IE7, IE8 and with IE protected mode.


• it works on all Windows versions: XP, Vista, Win7


• easily search of elements across all sub-documents inside frames/iframes hierarchy


• search HTML elements using regular expressions


• simulate user actions on all HTML controls (button, combo-box, list-box, edit-box, upload control) and fire all necessary HTML events


• auto-generate VBA code with powerful web recorder


• much more (see Twebst Automation Studio website)

That's all for now. Until our next encounter, check the download section below and have fun with the Excel VBA macro code.

Downloads:

• Twebst Automation Studio PRO this web automation tool is used in VBA maro so you have to install it first.


• TwebstVBA.zip containing sample XLS and BAS files.

Extract web data into Excel.Application with browser macro

Let's continue my previous post where I presented a browser macro that automatically translates phrases in an Excel document using Google Translate tool. As you cand see in code, the WSH script performs the following steps:

• instantiate "Twebst.Core" web automation object and start an IE browser.
• instantiate "Excel.Application" automation object and open XLS document.
• get a phrase to be translated from Excel document.
• navigate to Google translate tool web page.
• fill out web controls (the text to be translated, source and target language combo-boxes) and then automatically press submit button.
• wait the web page to load, get the translated text and save it into Excel document.

Let's see some code. I will skip the initial setup phase and go directly to web automation part which is more interesting:

for (var i = 1; i <= 5; ++i)
{
 // Get current text to translate from XLS document.
 var textToTranslate = excelApp.ActiveSheet.Cells(i, 1).Formula;

 // Web automation part implemented with Twebst Automatio Studio.
 browser.Navigate('http://www.google.com/language_tools?hl=en');
 browser.FindElement('textarea', 'id=source').InputText(textToTranslate);
 browser.FindElement('select', 'name=sl').Select('English');
 browser.FindElement('select', 'name=tl').Select('French');
 browser.FindElement('input submit', 'text=Translate').Click();

 // Get the reszult and save it into XLS document.
 var translatedText = browser.FindElement('span', 'id=result_box').text;
 excelApp.ActiveSheet.Cells(i, 2).Formula = translatedText;
}

Points of interest:

• FindElement method waits for the IE web page to be completely loaded before searching the element. The timeout value can be changed programatically (see loadTimeout, searchTimeout properties).
• InputText method sets the specified value in edit/password web controls and fires all necessary HTML events (onkeydown, onkeypress, onkeyup, onchange, etc).
• Select method fully automates combo-boxes and list-boxes web control and fires all necessary HTML events (like onchange).

Downloads:

• Twebst Automation Studio - you need to install this web automation tool before running the demo WSH script below.
• ExcelToWebMacro.zip - web scraping demo script that saves results into Excel file.