Hi Francois,
Here is the code for your requirement.
Set oExcel= CreateObject("Excel.Application")
Set oWorkbook = oExcel.workbooks.open("Path of Excel File")
Set oWorksheet = oWorkbook.Worksheets("Sheet Name")
Variable name = oWorksheet.cells(row number,column number)
Let me know in case you want more clarification.
Thanks,
Nishant
On Monday, January 13, 2014 8:14:10 PM UTC+5:30, Francois Rousseau wrote:
>
> Hi folks,
>
> The data I use for my scripts are stored in Excel workbook that we import
> in QTP. My problem is, I need to have references to other Excel file in my
> formulas to get the correct data for my scripts.
>
> Is there a way to import the value of a cell instead of the formula behind
> it?
>
> Would there be a way to do this an other way to get the values in my QTP
> datatable?
>
> Thank you!
>
--
--
You received this message because you are subscribed to the Google
"QTP - HP Quick Test Professional - Automated Software Testing"
group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/MercuryQTP?hl=en
---
You received this message because you are subscribed to the Google Groups "QTP
- HP Quick Test Professional - Automated Software Testing" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
