Service Functions – Excel (QTP, TestComplete, VBScript)
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.
Functions
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)
