Service Functions – Excel (QTP, TestComplete, VBScript)

Posted by Albert Gareev on Jan 12, 2010 | Categories: Function libraryMS Excel Data

In the code examples I present I often refer to routine functions.

In my framework I have specialized libraries to call from.  In my blog I maintain the similar structure.


Excel File Worksheet compare (QTP, VBScript)

How to check if Excel Workbook is locked

A little automation for VBScript OOP (1)

A little automation for VBScript OOP (2)

How To (answers)

How to open Excel workbook (QTP, VBScript)

How to use test data from a locked Excel Workbook (QTP, VBScript)

How to find Excel worksheet by name (QTP, VBScript)

Mapping Excel col names (QTP, VBScript)

How to find-replace empty cells (Excel, QTP, VBScript)

How to call Excel VBA function from QTP

How to exchange parameters with Excel VBA function (QTP, VBScript)

How to enlist Excel VBA macros (QTP, VBScript)

How to add (create) Excel macro from QTP

How to use Dictionary object for storing Excel data row (QTP, VBScript)

  • Leave a Reply

    * Required
    ** Your Email is never shared

Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported
This work by Albert Gareev is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported.