Say I have a QTP script which contains several reusable actions. The Global Datasheet contains a few parameters that are used by the other actions. So I want to pass these parameters between the actions’ datasheets. So logically I followed basic Excel functionality and did a point and click from one of the local datasheets to the global datasheets cell that I require. This works giving the following formula =Global!A1
A1 being the cell that I wanted to get the value of (i.e. Column A, Row 1).
However I will be reading in the Global Datasheet and the column headings may or may not reflect the “A” title. Therefore is it possible to re-write this formula (=Global!A1) so that it takes the column title that I have created in QTP? Eg. pUsername.
I logically tried to just do the following, but QTP did not like these:
=Global!”pUsername”1
=Global!pUsername1
I am looking for a solution to the above rather than alternative solutions, as I do have reasons for wanting to do it this way and I am aware that I could just take the parameter values from within the action.
Any help would be greatly appreciated.
A1 being the cell that I wanted to get the value of (i.e. Column A, Row 1).
However I will be reading in the Global Datasheet and the column headings may or may not reflect the “A” title. Therefore is it possible to re-write this formula (=Global!A1) so that it takes the column title that I have created in QTP? Eg. pUsername.
I logically tried to just do the following, but QTP did not like these:
=Global!”pUsername”1
=Global!pUsername1
I am looking for a solution to the above rather than alternative solutions, as I do have reasons for wanting to do it this way and I am aware that I could just take the parameter values from within the action.
Any help would be greatly appreciated.