Relevant Codes (by Anshoo Arora)

A Test Development Resource for HP QuickTest Professional.

VBScript

Over the past few years, I have read numerous threads and posts talking about working with Excel using VBScript. Not only have there been numerous threads, but also frameworks that use Excel as the input and/or driver engine. I wanted to work on this mini-project for a long time, and I finally have Version 1.0 of ExcelUtil ready for download! It comes with .CHM documentation.

{ 28 comments }

Over the past few weeks, I have been actively working on Quality Center (ALM) and its integration with QuickTest Professional. One of the mini-projects I’ve worked on is creating a custom object that executes a test set and sends an email to the supplied distribution list from ALM TestSet’s Automation tab. VBScript code available for download.

{ 17 comments }

This tip shows how to disable the Error message: “A script on this page is causing Internet Explorer to run slowly” with using VBScript.

{ 10 comments }

VBScript’s error handling techniques have been quite limited to On Error statements, and even though they satisfy our needs to some extent, the lack of incorporating dynamic behavior with them has been a much bigger issue. In this article, I will implement a Try-Catch-Finally statement with QTP’s GUI objects along with an On Error statement. This will enable dynamic behavior and enable us to easily divide flow depending on different error conditions.

{ 3 comments }

This topic covers the concepts of the Eval function and Execute statement in depth. The function Eval is used to evaluate a string and return the result of the string expression. The Execute statement on the other hand, executes one or more statements in a string expression and enables creation of dynamic code. Multiple statements can be executed at once by using colons or line breaks to separate them.

{ 43 comments }

This post shows a quick and easy way to compare 2 Excel files. I know there are several code snippets on the inter-webs that show how to compare 2 Excel files, but what makes this technique different is performance. I know faster techniques are possible, but after much experiment, this was the one that continuously worked at the best speed in comparison to other methods.

{ 73 comments }

The first release of RelevantCodes[1]One, a Keyword-Driven Automation Framework Demo Project is available and ready for download. Usage examples and Videos included.

{ Comments on this entry are closed }

QTP: Create Test Archives

by Anshoo Arora on August 27, 2009

This post explains how to create test archives elegantly and quickly and store all run-time files with a date and time stamp.

{ 0 comments }

Usage of modular classes helps in keeping all methods and properties for a module intact, and if done correctly, this can simply maintenance greatly.

{ 51 comments }

This article discusses 2 ways of sending e-mail from your Yahoo, Hotmail, Gmail, Live or AOL e-mail accounts using the ‘clsSendMail’ class:

{ 34 comments }

This topic outlines the use of XMLHTTP object in VBSCript. It will show how to retrieve Server-side response without physically opening the page.

{ 3 comments }

In this topic we will learn how to pass 2 or more values from function using Global Variables, Arrays, Dictionary Objects, Concatenated Strings and with the use of ByRef.

{ 3 comments }

This article demonstrates the differences between ByRef and ByVal in VBScript. It will also provide the pros and cons and excellent examples to get you started immediately.

{ 17 comments }