Taking value from Action1 sheet
I have a excel sheet in which there are two default sheets - Global and Action1. In global sheet, there is a column 'Alpha' and there three values in this sheet 1,2, and 3 in Alpha1, Alpha2 and Alpha3 column repectively. Similarly there are three values in Action1 sheet. The name of the column in Action1 sheet is 'Beta'. To take the value from 'Alpha' I use the following script:
but if I change 'Alpha' to 'Beta' it still look for the column 'Beta' in global sheet itself. Can you tell me how to take value from 'Action1' sheet? I will be thankful to you.
Re: Taking value from Action1 sheet
there was an equal topic a few days ago.......
(would be great to consultate the handbook and the online help of QTP before posting...)
to access your action sheet you have to use "dtLocalSheet". see the online help of QTP for working with the sheets included in your script
if you want to have a look at the action sheet for your Beta Value you have to use
de omnibus dubitandum
For all Questions: Please be sure to take a look at the QTP Manual before posting any Questions, thanks for doing this