QTP test script for MS Excel spread sheet

[mintu]

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

[VENKATAREDDY_M]

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

[mintu]

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

[niranjan]

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.