{"id":12181,"date":"2013-09-12T19:38:31","date_gmt":"2013-09-12T19:38:31","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=3121"},"modified":"2022-08-05T18:04:33","modified_gmt":"2022-08-05T18:04:33","slug":"qc-connect-excel-macro","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2013\/09\/qc-connect-excel-macro\/","title":{"rendered":"HP Quality Center &#8211; Connect to HP QC using Excel VBA"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;section&#8221; _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221; da_disable_devices=&#8221;off|off|off&#8221;][et_pb_row admin_label=&#8221;row&#8221; _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.17.6&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; sticky_enabled=&#8221;0&#8243;]Dear Reader,<\/p>\n<p>This is the first article of <span class=\"pa-color-highlight\">HP QC VBA Tutorial.<\/span> In this article I will show you the first step which you should know before doing any automation related to Quality Center using Excel Macro. That first step is nothing but connecting to the Quality Center using excel macro. As you might have seen on the Quality Center UI (User Interface), Login to Quality Center consists of two steps:<\/p>\n<ul>\n<h4>\n<li>1. Authenticate your User ID and Password<\/li>\n<\/h4>\n<h4>\n<li>2. On Successful Authentication all the Domains and Projects appear in the below dropdown<\/li>\n<\/h4>\n<ul>\n<p><img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2013\/09\/HP_QC_Authentication-e1379014340835.png\" alt=\"Quality Center Login (Authentication)\" title=\"Quality Center Login (Authentication)\" width=\"600\" height=\"351\" class=\"size-full wp-image-3124\" \/><\/p>\n<p>In the same way, QC connection using VBA is also done in 2 steps:<br \/>\nFirst Authenticate your credentials (User ID and Password)<br \/>\nThen connect to QC using Domain and Project names.<\/p>\n<pre><code class=\"language-vbnet\">\nSub ConnectToQualityCenter()\n\nDim qcURL As String\nDim qcID As String\nDim qcPWD As String\nDim qcDomain As String\nDim qcProject As String\nDim tdConnection As Object\n\nOn Error GoTo err\n   qcURL = &lt;QC URL&gt; 'Example : https:\/\/&lt;server url&gt;\/qcbin\n   qcID = &lt;your User ID&gt;\n   qcPWD = &lt;Your password&gt;\n   qcDomain = &lt;Domain Name&gt;\n   qcProject = &lt;Project Name&gt;\n'Display a message in Status bar\n   Application.StatusBar = \"Connecting to Quality Center.. Wait...\"\n' Create a Connection object to connect to Quality Center\n   Set tdConnection = CreateObject(\"TDApiOle80.TDConnection\")\n'Initialise the Quality center connection\n   tdConnection.InitConnectionEx qcURL\n'Authenticating with username and password\n   tdConnection.Login qcID, qcPWD\n'connecting to the domain and project\n   tdConnection.Connect qcDomain, qcProject\n'On successfull login display message in Status bar\n   Application.StatusBar = \"........QC Connection is done Successfully\"\n   Exit Sub\nerr:\n'Display the error message in Status bar\nApplication.StatusBar = err.Description\nEnd Sub\n<\/code><\/pre>\n<p><span class=\"pa-callout-2\"><i>Note: URL which you are passing, should always be till https:\/\/&lt;server url&gt;<strong>\/qcbin<\/strong> only.<\/i><\/span><\/p>\n<p>Using the above code, now you are connected with the Quality center for a given Domain and project. Object <span class=\"pa-color-highlight\"><strong>tdConnection<\/strong><\/span> as defined above can be used to access each and every objects available in the Quality Center, like Test Cases, Requirements, Defects etc.<\/p>\n<p>In the coming articles, we will learn more about the objects inside the quality center after authentication is successful.<br \/>\n[\/et_pb_text][et_pb_blurb _builder_version=&#8221;4.17.6&#8243; _module_preset=&#8221;5aa1bb27-c61b-41a1-b1dc-3feced0f8b7b&#8221; title=&#8221;You may also like these articles:&#8221; use_icon=&#8221;on&#8221; font_icon=&#8221;&#xf0c1;||fa||900&#8243; hover_enabled=&#8221;0&#8243; sticky_enabled=&#8221;0&#8243;]<\/p>\n<ol>\n<li><a href=\"https:\/\/vmlogger.com\/excel\/2013\/09\/check-hp-alm-connection-using-vba\/\" target=\"_blank\" rel=\"noopener\">HP Quality Center &#8211; Check if Connection to QC is made<\/a><\/li>\n<li><a href=\"https:\/\/vmlogger.com\/excel\/2013\/09\/download-test-cases-from-qc\/\" target=\"_blank\" rel=\"noopener\">HP Quality Center &#8211; Excel Macro to Import Test Cases from QC<\/a><\/li>\n<li><a href=\"https:\/\/vmlogger.com\/excel\/2013\/09\/create-folder-in-qc-testlab\/\" target=\"_blank\" rel=\"noopener\">HP Quality Center &#8211; Create Folder Structure in Test Lab<\/a><\/li>\n<li><a href=\"https:\/\/vmlogger.com\/excel\/2014\/06\/excel-cell-masking-for-password\/\" target=\"_blank\" rel=\"noopener\">Excel Tip : How to Make an Excel Cell secured for Password<\/a><\/li>\n<li><a href=\"https:\/\/vmlogger.com\/excel\/2015\/12\/visible-range-in-excel-active-window\/\" target=\"_blank\" rel=\"noopener\">Excel Tip : How to Make an Excel Cell secured for Password<\/a><\/li>\n<\/ol>\n<p>[\/et_pb_blurb][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n<span class=\"et_bloom_bottom_trigger\"><\/span>","protected":false},"excerpt":{"rendered":"<p>Dear Reader, This is the first article of HP QC VBA Tutorial. In this article I will show you the first step which you should know before doing any automation related to Quality Center using Excel Macro. That first step is nothing but connecting to the Quality Center using excel macro. As you might have [&hellip;]<\/p>\n","protected":false},"author":45,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1675,1677],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.9 (Yoast SEO v21.9.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>HP Quality Center - Connect to HP QC using Excel VBA - Let&#039;s excel in Excel<\/title>\n<meta name=\"description\" content=\"Want to connect to HP QC using Excel VBA? How to connect to HP Quality Center via Excel Macro? How to Authenticate HP QC via Excel VBA Code?\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vmlogger.com\/excel\/2013\/09\/qc-connect-excel-macro\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"HP Quality Center - Connect to HP QC using Excel VBA\" \/>\n<meta property=\"og:description\" content=\"Want to connect to HP QC using Excel VBA? How to connect to HP Quality Center via Excel Macro? How to Authenticate HP QC via Excel VBA Code?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2013\/09\/qc-connect-excel-macro\/\" \/>\n<meta property=\"og:site_name\" content=\"Let&#039;s excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2013-09-12T19:38:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-05T18:04:33+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/learnexcelmacro.com\/wp\/wp-content\/uploads\/sites\/11\/2013\/09\/HP_QC_Authentication-e1379014340835.png\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2013\/09\/qc-connect-excel-macro\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2013\/09\/qc-connect-excel-macro\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"HP Quality Center &#8211; Connect to HP QC using Excel VBA\",\"datePublished\":\"2013-09-12T19:38:31+00:00\",\"dateModified\":\"2022-08-05T18:04:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2013\/09\/qc-connect-excel-macro\/\"},\"wordCount\":419,\"commentCount\":86,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"articleSection\":[\"Excel Macro Tutorial\",\"HP QC\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2013\/09\/qc-connect-excel-macro\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2013\/09\/qc-connect-excel-macro\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2013\/09\/qc-connect-excel-macro\/\",\"name\":\"HP Quality Center - Connect to HP QC using Excel VBA - Let&#039;s excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"datePublished\":\"2013-09-12T19:38:31+00:00\",\"dateModified\":\"2022-08-05T18:04:33+00:00\",\"description\":\"Want to connect to HP QC using Excel VBA? How to connect to HP Quality Center via Excel Macro? How to Authenticate HP QC via Excel VBA Code?\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2013\/09\/qc-connect-excel-macro\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2013\/09\/qc-connect-excel-macro\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2013\/09\/qc-connect-excel-macro\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Macro Tutorial\",\"item\":\"https:\/\/vmlogger.com\/excel\/excel-macro-for-beginners\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"HP Quality Center &#8211; Connect to HP QC using Excel VBA\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let&#039;s excel in Excel\",\"description\":\"Let&#039;s share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore &amp; currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/twitter.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"HP Quality Center - Connect to HP QC using Excel VBA - Let&#039;s excel in Excel","description":"Want to connect to HP QC using Excel VBA? How to connect to HP Quality Center via Excel Macro? How to Authenticate HP QC via Excel VBA Code?","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/vmlogger.com\/excel\/2013\/09\/qc-connect-excel-macro\/","og_locale":"en_US","og_type":"article","og_title":"HP Quality Center - Connect to HP QC using Excel VBA","og_description":"Want to connect to HP QC using Excel VBA? How to connect to HP Quality Center via Excel Macro? How to Authenticate HP QC via Excel VBA Code?","og_url":"https:\/\/vmlogger.com\/excel\/2013\/09\/qc-connect-excel-macro\/","og_site_name":"Let&#039;s excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2013-09-12T19:38:31+00:00","article_modified_time":"2022-08-05T18:04:33+00:00","og_image":[{"url":"http:\/\/learnexcelmacro.com\/wp\/wp-content\/uploads\/sites\/11\/2013\/09\/HP_QC_Authentication-e1379014340835.png"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2013\/09\/qc-connect-excel-macro\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2013\/09\/qc-connect-excel-macro\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"HP Quality Center &#8211; Connect to HP QC using Excel VBA","datePublished":"2013-09-12T19:38:31+00:00","dateModified":"2022-08-05T18:04:33+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2013\/09\/qc-connect-excel-macro\/"},"wordCount":419,"commentCount":86,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"articleSection":["Excel Macro Tutorial","HP QC"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2013\/09\/qc-connect-excel-macro\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2013\/09\/qc-connect-excel-macro\/","url":"https:\/\/vmlogger.com\/excel\/2013\/09\/qc-connect-excel-macro\/","name":"HP Quality Center - Connect to HP QC using Excel VBA - Let&#039;s excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"datePublished":"2013-09-12T19:38:31+00:00","dateModified":"2022-08-05T18:04:33+00:00","description":"Want to connect to HP QC using Excel VBA? How to connect to HP Quality Center via Excel Macro? How to Authenticate HP QC via Excel VBA Code?","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2013\/09\/qc-connect-excel-macro\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2013\/09\/qc-connect-excel-macro\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2013\/09\/qc-connect-excel-macro\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Macro Tutorial","item":"https:\/\/vmlogger.com\/excel\/excel-macro-for-beginners\/"},{"@type":"ListItem","position":3,"name":"HP Quality Center &#8211; Connect to HP QC using Excel VBA"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let&#039;s excel in Excel","description":"Let&#039;s share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore &amp; currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/twitter.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12181"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=12181"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12181\/revisions"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=12181"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=12181"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=12181"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}