+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: QTP test script for MS Excel spread sheet (/Thread-QTP-test-script-for-MS-Excel-spread-sheet)
QTP test script for MS Excel spread sheet - mintu - 10-03-2008
Hello,
I am a QTP Beginner. I am trying to create a automated test scripts using QTP 9.0 on MS Excel spread sheet. In the script I am trying to change the Font and Font color for some text I have entered in some of the cells. When I try to run my recorded script it fails. As per my understanding there is some problem in class definition. Not sure how to fix this.
Could anyone please help?
I have attached the script and the error I am receiving.
Your help will be highly appreciated.
Regards,
Mintu
RE: QTP test script for MS Excel spread sheet - VENKATAREDDY_M - 10-06-2008
Hi
You have recorded actions on Excel using QTP
This is not good approach to automate Excel.
We have Excel Object Model available in Internet.
Pls go through and try in that approach. Then you can do any thing in Excel.
-VENKATA REDDY
RE: QTP test script for MS Excel spread sheet - mintu - 10-07-2008
Thanks Venkatareddy!
May I ask you how Excel Object Model will help me recording excel test script? I am not very clear on that. Can you please explain more on that?
Also I tried to find out on the internet but couldn't find anything.
Thanks, Mintu
RE: QTP test script for MS Excel spread sheet - niranjan - 10-07-2008
Check Quick Test Code Sample plus and you will find sample code on how to create and use Excel Object.
It comes with QTP installation for 9.x.