VBScript to Get Cell Value of Particular Row and Column From ExcelSheet

How to get data from a particular row and a particular column from Excel Sheet in QTP?

Check This Post For Script To Get Cell Value of Particular Row and Column From Datatable in QTP.

QTP Script to get particular cell value from ExcelSheet in the specified row.

Below script is for retrieving 2rd row,2rd column cell value from already existing excelsheet in D drive.

In excelsheet we have values as shown below

A B C
1 aa xx
2 bb yy
3 cc zz

Script to get value "bb" from ExcelSheet is

Set a=createobject("Excel.application")
Set b=a.workbooks.open("D:\es.xls")
Set c=b.worksheets("Sheet1")
d=c.cells(2,2).value
msgbox d
b.close

Similarly to retrieve 3rd row,1column value(3)replace d=c.cells(2,2).value with
d=c.cells(3,1).value in the above script.

SQL Queries Collection
Movie Songs Lyrics

Other QTP Scripts
VBScript to Check Whether Particular File Exists or Not.
Check this Post for Datatable Methods.
Excel Sheet Creation and Writing Data Into It
Data Driven Using Excel Sheet
Data Driven Using Notepad