I have a scenario and needs help.
I am creating an excel sheet(object)and need to perform few operations like...
Inserting a pivort table(In Excel->data->pivort table)
(I do this by recording in the sheet)
Now the problem is that the excel sheet changes often, and when I run my script again with a different "sheet name" it throws an error "Object not found in Repository)
Is there is any way I can update an object during run time.
(Now I am working by changing my sheet name to the one in repository.)
since my excel sheet's "name" changes I cant perform any Recorded operation (Like clicking,inserting values)
Please help me regarding the same.
Any insights to exoke and handle randomly changing sheets(Name)are welcome.
Post your code
Buy the NEW QTP Descriptive Programming Unplugged Book
** Download QTP Unplugged 2nd Edition eBook for FREE **
Post deleted by FordsRock
Quality Control Analyst at Syntel Inc
Project Test Lead for client Daimler Trucks - North America.
Interested in testing dot net web services and SOA systems.
Charles F. Radley
Record & Playback is not a good idea with Excel. You need to seach for "Excel COM"
Look in the "User Donated Functions" topic at the top of the forum, there is enough code in there to get you started.
My linkedIn Profile