Usually for automating Excel people don't use QTP. Is there special reason you don't use automation with COM?
On Wed, Jun 2, 2010 at 2:06 AM, manjunath biradar <[email protected]>wrote: > Hi Abhijeet, > > Below are the details of the automation i am working on... > > QTP version : 9.5 > Excel 2007 > OS: WinXp > > > On Tue, Jun 1, 2010 at 12:28 PM, Abhijeet <[email protected]> wrote: > >> Hi Manjunath, >> >> My answer here is based on what I worked on. I don't know upto what >> extent you have automated this application. So, some of the points >> here may also be redundant / useless to you. >> >> 1. The automation strategy will depend on office version also. Which >> version of excel / office are you using ? The reason for this question >> is office 2007 is way different than the office XP, and needs >> different ways of navigating. >> >> For the navigation purposes, it's always best to use the shortcut keys >> for automation. Let's assume the addin has the shortcut of "ALT+X+P" >> to be able to navigate. You can notice the difference, in office 2007, >> you just have to press ALT key once, and release, and then you can >> press X and P as and when required. You don't have to hold on to the >> ALT key. In office XP version, you have to hold on to the ALT key >> until you are done. >> >> 2. WPF : Are you using QTP 9.5 or 10 ? Ideally it should be QTP 10. Do >> you have the latest patch installed ? The latest patch is called >> something like "patch 38" (QTPNET_00038).I don't have it's proper name >> right now. Also, make sure that you refer to the documentation of the >> patch, as for this patch it is required that a particular patch (I >> believe QTPNET_00015) for wpf SHOULD NOT be present while installing >> this new patch. >> >> Please check the link : >> http://www.sqaforums.com/showflat.php?Cat=0&Number=625380&an=0&page=0 >> >> Also try to find out from the HP resource center if they have any new >> patch for WPF. They keep on releasing new patches regularly based on >> tickets. If you are facing problems about QTP identifying some objects >> properly and not the others, chances are some of the object >> properties / methods are not exposed by the developers, and if it is >> proper, then you can work with HP to open up a ticket. >> >> - Abhijeet >> >> >> On May 31, 1:26 pm, manjunath biradar <[email protected]> wrote: >> > Hi, >> > >> > I am facing a peculiar problem.. I have an add-in in the excel to be >> > automated and when i try object identification i am able to see only the >> > "Book1" being recognized and everything else is identified as an object. >> I >> > have the wpf addin with licensed version but no luck... >> > >> > The addin is built with Wpf objects. Even tried creating a new object >> set by >> > selecting Wpf standard object but no luck, >> > >> > So can one please advise on this.. as i have a very tight deadline to >> > finish. :) >> > >> > Cheers >> > Xpressmusic >> >> -- >> You received this message because you are subscribed to the Google >> "QTP - HP Quick Test Professional - Automated Software Testing" >> group. >> To post to this group, send email to [email protected] >> To unsubscribe from this group, send email to >> [email protected]<mercuryqtp%[email protected]> >> For more options, visit this group at >> http://groups.google.com/group/MercuryQTP?hl=en >> > > -- > You received this message because you are subscribed to the Google > "QTP - HP Quick Test Professional - Automated Software Testing" > group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected]<mercuryqtp%[email protected]> > For more options, visit this group at > http://groups.google.com/group/MercuryQTP?hl=en > -- You received this message because you are subscribed to the Google "QTP - HP Quick Test Professional - Automated Software Testing" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/MercuryQTP?hl=en
