Hi Nevin I have been following this discussion and wondering how we can get the information necessary to help you.
Is the software you call QC the HP Quality Center software? If not what is it? Do you know any way to connect Excel with it manually? If so how do you do it? If you can connect is this a read-only connection or can you alter the QC database? If you want to mark a test as passed or failed in QC how do you do it? Please include in your answer all connection strings, file addresses, web addresses, and screen prints as relevant. Have you tried asking your question opn the QC forum? What response did you get? Regards David Grugeon On 5 November 2012 08:08, Nevin <mail2ne...@gmail.com> wrote: > Hi Paul/Rajan/Friends, > I have attached a POC of what exactly iam planning to do with all the > business validation. > My idea is to develop an macros for updating test cases results in QC.Iam > planning to develop this tool keeping regression testing in my mind. > When we do regression testing for an application after a patch relase > there are very few defect and most of the cases are passed. > > Eg :- if 1000 test cases are availbale in Quality center and only 10 test > cases are failed in it per regression cycle.I want to mark 10 test cases as > fail in the excel macro and click on the button it should update those 10 > test cases as fail in quality center and by default all remaining 990 test > cases which are not mentioned in the excel should be marked as pass in > quality center.This will help us reduce lot of manual redundant work which > we are doing currently > > It would be great if somebody you are guiding me.Thanks a lot once again. > > Regards > Nevin > > On Wednesday, October 31, 2012 11:49:01 AM UTC-5, Nevin wrote: > >> Hi Friends, >> >> Iam not able to find the right kind of code which is used to connect >> QC test lab folder using macros.Objective is to update around 1200 tc >> using macros. >> >> It would be great if somebody is guiding me and iam very new to using >> macros.. >> >> Regards >> > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
