Share xls file between many QTP scripts

[adam12]

Hi everyone,

Is it possible to share one xls file between 2 QTP test script? For example i want to run 2 identicial script, which do the same thing. I try to figur out how to do this but i cant resolve this problem. There is a problem with access mangament to xls file for example first script cant perform the same row from xls as second script already do. I try receive this through ReadOnly property xls file - when first script get work for himself form xls then second cant access this xls file and etc. This attitude to problem may prevent from sytuaction in which first script do the same thing as second. ReadOnly attitude unfortunetly doesnt work. Any ideas?

Thanks,
Adam

[Tarik Sheth]

Hi,

What you can do is create a ADODB connection to the excel sheet and then try to create a record set and from the record set get the required value.

[adam12]

Thank for your reply

I unfortunately dont understand how ADODB can help resolve my problem. I want control access to xls file to only one script at the same time can read/write to this xls. Could you explain what do you mean?

[Tarik Sheth]

What I meant was to create an ADODB database connection just same as one does for connecting to db through QTP, i this way you can create record set for excel and read values simultaneously from multiple scripts.