I know that the excel is the toughest application to automate and given the changes happening in my product each day.. hectic but cant help Boss are behind me to complete and i dont knw hw the hell i will do it.... I guess need to make the boss understand the situation here :)
On Thu, Jun 3, 2010 at 6:25 AM, Roman Zilber <[email protected]> wrote: > 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]<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
