{"id":12184,"date":"2013-09-22T16:15:20","date_gmt":"2013-09-22T16:15:20","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=3195"},"modified":"2022-08-07T06:04:06","modified_gmt":"2022-08-07T06:04:06","slug":"download-test-cases-from-qc","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2013\/09\/download-test-cases-from-qc\/","title":{"rendered":"HP Quality Center – Excel Macro to Import Test Cases from QC"},"content":{"rendered":"

In this article, I am going to share the VBA code to download the test cases from QC in Excel Sheet. Here in this example, I will fetch very few important fields from QC but if you want more fields to be fetched then it can be easily done. I have categorized this VBA code into two main categories:<\/p>\n

1. Download Test Cases without Test Steps <\/h4>\n

2. Download Test Cases With Test Steps<\/h4>\n

1. Download Test Cases without Test Steps<\/h1>\n

Copy and paste the below code into your excel VBA module. Make the necessary changes like your QC ID, Password, URL, path, etc. and enjoy running the code \ud83d\ude42<\/p>\n

\r\nFunction EmportTestCases()\r\n    On Error Resume Next\r\n    Dim QCConnection\r\n    Dim sUserName, sPassword\r\n    Dim sDomain, sProject\r\n    Dim TstFactory, TestList\r\n    Dim TestCase\r\n'Create QC Connection Object to connect to QC\r\n    Set QCConnection = CreateObject(\"TDApiOle80.TDConnection\")\r\n    sUserName = \"your user id\"\r\n    sPassword = \"your password\"\r\n    QCConnection.InitConnectionEx \"your QC URL\/qcbin\"\r\n'Authenticate your user ID and Password\r\n    QCConnection.Login sUserName, sPassword\r\n'Quit if QC Authentication fails\r\n    If (QCConnection.LoggedIn <> True) Then\r\n        MsgBox \"QC User Authentication Failed\"\r\n        End\r\n    End If\r\n    sDomain = \"your domain name\"\r\n    sProject = \"your project name\"\r\n'Login to your Domain and Project\r\n    QCConnection.Connect sDomain, sProject\r\n'Quit if login fails to specified Domain and Project\r\n    If (QCConnection.AuthenticationToken = \"\") Then\r\n        MsgBox \"QC Project Failed to Connect to \" & sProject\r\n        QCConnection.Disconnect\r\n        End\r\n    End If\r\n'Now successful connection is made to QC\r\n'Get the test factory\r\n    Set TstFactory = QCConnection.TestFactory\r\n' Your QC Project Path for which you want to download\r\n' the test cases.\r\n    fpath = \"your project folder\" \r\n    Set myfilter = TstFactory.Filter()\r\n    myfilter.Filter(\"TS_SUBJECT\") =\"^\" & fpath & \"^\"\r\n'Get a list of all test cases for your specified path\r\n    Set TestList = myfilter.NewList()\r\n'Format the header before downloading the test cases\r\n    With ActiveSheet\r\n        .Range(\"B5\").Select\r\n        With .Range(\"B4:F4\")\r\n            .Font.Name = \"Arial\"\r\n            .Font.FontStyle = \"Bold\"\r\n            .Font.Size = 10\r\n            .Font.Bold = True\r\n            .HorizontalAlignment = xlCenter\r\n            .VerticalAlignment = xlCenter\r\n            .Interior.ColorIndex = 15\r\n        End With\r\n        .Cells(4, 2) = \"Subject (Folder Name)\"\r\n        .Cells(4, 3) = \"Test Name (Manual Test Plan Name)\"\r\n        .Cells(4, 4) = \"Description\"\r\n        .Cells(4, 5) = \"Status\"\r\n        Dim Row\r\n        Row = 5 '- set the data row from 5\r\n'loop through all the test cases.\r\n        For Each TestCase In TestList\r\n            .Cells(Row, 2).Value = TestCase.Field(\"TS_SUBJECT\").Path\r\n            .Cells(Row, 3).Value = TestCase.Field(\"TS_NAME\")\r\n'QC stores description in html format. So before storing it\r\n'in to excel, StripHTML() will remove all HTML tags and put\r\n'texts only. Also new line tag 
 is replaced with new line\r\n'character chr(10) in excel so that all the new line texts appears properly\r\n            .Cells(Row, 4).Value = StripHTML(Replace(TestCase.Field(\"TS_DESCRIPTION\"), _\r\n \"<br>\", Chr(10)))\r\n            .Cells(Row, 5).Value = TestCase.Field(\"TS_EXEC_STATUS\")\r\n            Row = Row + 1\r\n        Next ' Next test case\r\n    End With\r\n    'Release the object\r\n    Set DesignStepFactory = Nothing\r\n    Set DesignStep = Nothing\r\n    Set DesignStepList = Nothing\r\n    Set TstFactory = Nothing\r\n    Set TestList = Nothing\r\n    Set TestCase = Nothing\r\n    QCConnection.Disconnect\r\n    MsgBox (\"All Test cases are downloaded without Test Steps\")\r\nEnd Function\r\n\r\nFunction StripHTML(sInput As String) As String\r\n    Dim RegEx As Object\r\n    Set RegEx = CreateObject(\"vbscript.regexp\")\r\n    Dim sInput As String\r\n    Dim sOut As String\r\n    sInput = cell.Text\r\n    With RegEx\r\n        .Global = True\r\n        .IgnoreCase = True\r\n        .MultiLine = True\r\n        .Pattern = \"<[^>]+>\" 'Regular Expression for HTML Tags.\r\n    End With\r\n    sOut = RegEx.Replace(sInput, \"\")\r\n    StripHTML = sOut\r\n    Set RegEx = Nothing\r\nEnd Function\r\n<\/code><\/pre>\n
<\/a>
\n <\/p>\n
2. Download Test Cases with Test Steps<\/h1>\n
\r\nFunction EmportTestCases()\r\n    On Error Resume Next\r\n    Dim QCConnection\r\n    Dim sUserName, sPassword\r\n    Dim sDomain, sProject\r\n    Dim TstFactory, TestList\r\n    Dim TestCase\r\n'Create QC Connection Object to connect to QC\r\n    Set QCConnection = CreateObject(\"TDApiOle80.TDConnection\")\r\n    sUserName = \"your user id\"\r\n    sPassword = \"your password\"\r\n    QCConnection.InitConnectionEx \"your QC URL\/qcbin\"\r\n'Authenticate your user ID and Password\r\n    QCConnection.Login sUserName, sPassword\r\n'Quit if QC Authentication fails\r\n    If (QCConnection.LoggedIn <> True) Then\r\n        MsgBox \"QC User Authentication Failed\"\r\n        End\r\n    End If\r\n    sDomain = \"your domain name\"\r\n    sProject = \"your project name\"\r\n'Login to your Domain and Project\r\n    QCConnection.Connect sDomain, sProject\r\n'Quit if login fails to specified Domain and Project\r\n    If (QCConnection.AuthenticationToken = \"\") Then\r\n        MsgBox \"QC Project Failed to Connect to \" & sProject\r\n        QCConnection.Disconnect\r\n        End\r\n    End If\r\n'Now successful connection is made to QC\r\n'Get the test factory\r\n    Set TstFactory = QCConnection.TestFactory\r\n' Your QC Project Path for which you want to download\r\n' the test cases.\r\n    fpath = \"your project folder\" \r\n    Set myfilter = TstFactory.Filter()\r\n    myfilter.Filter(\"TS_SUBJECT\") = \"^\" & fpath & \"^\"\r\n'Get a list of all test cases for your specified path\r\n    Set TestList = myfilter.NewList()\r\n'Format the header before downloading the test cases\r\n    With ActiveSheet\r\n        .Range(\"B5\").Select\r\n        With .Range(\"B4:H4\")\r\n            .Font.Name = \"Arial\"\r\n            .Font.FontStyle = \"Bold\"\r\n            .Font.Size = 10\r\n            .Font.Bold = True\r\n            .HorizontalAlignment = xlCenter\r\n            .VerticalAlignment = xlCenter\r\n            .Interior.ColorIndex = 15\r\n        End With\r\n        .Cells(4, 2) = \"Subject (Folder Name)\"\r\n        .Cells(4, 3) = \"Test Name (Manual Test Plan Name)\"\r\n        .Cells(4, 4) = \"Description\"\r\n        .Cells(4, 5) = \"Status\"\r\n        .Cells(4, 6) = \"Step Name\"\r\n        .Cells(4, 7) = \"Step Description(Action)\"\r\n        .Cells(4, 8) = \"Expected Result\"\r\n        Dim Row\r\n        Row = 5 '- set the data row from 5\r\n'loop through all the test cases.\r\n        For Each TestCase In TestList\r\n            .Cells(Row, 2).Value = TestCase.Field(\"TS_SUBJECT\").Path\r\n            .Cells(Row, 3).Value = TestCase.Field(\"TS_NAME\")\r\n'QC stores description in html format. So before storing it\r\n'in to excel, StripHTML() will remove all HTML tags and put\r\n'texts only. Also new line tag 
 is replaced with new line\r\n'character chr(10) in excel so that all the new line texts appears properly\r\n            .Cells(Row, 4).Value = StripHTML(Replace(TestCase.Field(\"TS_DESCRIPTION\"), _\r\n \"<br>\", Chr(10)))\r\n            .Cells(Row, 5).Value = TestCase.Field(\"TS_EXEC_STATUS\")\r\n'Get the DesignStepFactory for the this testcase\r\n            Dim DesignStepFactory, DesignStep, DesignStepList\r\n            Set DesignStepFactory = TestCase.DesignStepFactory\r\n            Set DesignStepList = DesignStepFactory.NewList(\"\")\r\n'Check if design steps exists for the test\r\n            If DesignStepList.Count <> 0 Then\r\n'loop for all the steps for this test case\r\n                For Each DesignStep In DesignStepList\r\n                    .Cells(Row, 6).Value = DesignStep.StepName\r\n                    .Cells(Row, 7).Value = StripHTML(Replace(DesignStep.StepDescription, _\r\n \"<br>\", Chr(10)))\r\n                    .Cells(Row, 8).Value = StripHTML(Replace(DesignStep.StepExpectedResult, _\r\n \"<br>\", Chr(10)))\r\n                    Row = Row + 1\r\n                Next 'next Step\r\n            End If\r\n            ' release the design step objects\r\n            Set DesignStepFactory = Nothing\r\n            Set DesignStep = Nothing\r\n            Set DesignStepList = Nothing\r\n        Next ' Next test case\r\n    End With\r\n    'Release the object\r\n    Set DesignStepFactory = Nothing\r\n    Set DesignStep = Nothing\r\n    Set DesignStepList = Nothing\r\n    Set TstFactory = Nothing\r\n    Set TestList = Nothing\r\n    Set TestCase = Nothing\r\n    QCConnection.Disconnect\r\n    MsgBox (\"All Test cases are downloaded with Test Steps\")\r\nEnd Function\r\n\r\nFunction StripHTML(sInput As String) As String\r\n    Dim RegEx As Object\r\n    Set RegEx = CreateObject(\"vbscript.regexp\")\r\n    Dim sInput As String\r\n    Dim sOut As String\r\n    sInput = cell.Text\r\n    With RegEx\r\n        .Global = True\r\n        .IgnoreCase = True\r\n        .MultiLine = True\r\n        .Pattern = \"<[^>]+>\" 'Regular Expression for HTML Tags.\r\n    End With\r\n    sOut = RegEx.Replace(sInput, \"\")\r\n    StripHTML = sOut\r\n    Set RegEx = Nothing\r\nEnd Function\r\n<\/code><\/pre>\n<\/span>","protected":false},"excerpt":{"rendered":"
In this article, I am going to share the VBA code to download the test cases from QC in Excel Sheet. Here in this example, I will fetch very few important fields from QC but if you want more fields to be fetched then it can be easily done. I have categorized this VBA code […]<\/p>\n","protected":false},"author":45,"featured_media":242647,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1246,1675,1677],"tags":[],"class_list":["post-12184","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-macro","category-excel-macro-for-beginners","category-hp-qc"],"yoast_head":"\nHP Quality Center - Excel Macro to Import Test Cases from QC - Let's excel in Excel<\/title>\n<meta name=\"description\" content=\"Download the test cases from QC in Excel Sheet using VBA. Pull Test cases from HP QC in Excel Sheet automatically via Excel Macro.\" \/>\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\/download-test-cases-from-qc\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"HP Quality Center - Excel Macro to Import Test Cases from QC\" \/>\n<meta property=\"og:description\" content=\"Download the test cases from QC in Excel Sheet using VBA. Pull Test cases from HP QC in Excel Sheet automatically via Excel Macro.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2013\/09\/download-test-cases-from-qc\/\" \/>\n<meta property=\"og:site_name\" content=\"Let'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-22T16:15:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-07T06:04:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2013\/09\/Macro-to-download-testcases-from-qc.png\" \/>\n\t<meta property=\"og:image:width\" content=\"400\" \/>\n\t<meta property=\"og:image:height\" content=\"250\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/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\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2013\/09\/download-test-cases-from-qc\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2013\/09\/download-test-cases-from-qc\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"HP Quality Center – Excel Macro to Import Test Cases from QC\",\"datePublished\":\"2013-09-22T16:15:20+00:00\",\"dateModified\":\"2022-08-07T06:04:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2013\/09\/download-test-cases-from-qc\/\"},\"wordCount\":124,\"commentCount\":51,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2013\/09\/download-test-cases-from-qc\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2013\/09\/Macro-to-download-testcases-from-qc.png\",\"articleSection\":[\"Excel Macro\",\"Excel Macro Tutorial\",\"HP QC\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2013\/09\/download-test-cases-from-qc\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2013\/09\/download-test-cases-from-qc\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2013\/09\/download-test-cases-from-qc\/\",\"name\":\"HP Quality Center - Excel Macro to Import Test Cases from QC - Let's excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2013\/09\/download-test-cases-from-qc\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2013\/09\/download-test-cases-from-qc\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2013\/09\/Macro-to-download-testcases-from-qc.png\",\"datePublished\":\"2013-09-22T16:15:20+00:00\",\"dateModified\":\"2022-08-07T06:04:06+00:00\",\"description\":\"Download the test cases from QC in Excel Sheet using VBA. Pull Test cases from HP QC in Excel Sheet automatically via Excel Macro.\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2013\/09\/download-test-cases-from-qc\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2013\/09\/download-test-cases-from-qc\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2013\/09\/download-test-cases-from-qc\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2013\/09\/Macro-to-download-testcases-from-qc.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2013\/09\/Macro-to-download-testcases-from-qc.png\",\"width\":400,\"height\":250,\"caption\":\"Macro to download test cases from QC\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2013\/09\/download-test-cases-from-qc\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Macro\",\"item\":\"https:\/\/vmlogger.com\/excel\/macro\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"HP Quality Center – Excel Macro to Import Test Cases from QC\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let's excel in Excel\",\"description\":\"Let'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\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"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 & currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/x.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 - Excel Macro to Import Test Cases from QC - Let's excel in Excel","description":"Download the test cases from QC in Excel Sheet using VBA. Pull Test cases from HP QC in Excel Sheet automatically via Excel Macro.","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\/download-test-cases-from-qc\/","og_locale":"en_US","og_type":"article","og_title":"HP Quality Center - Excel Macro to Import Test Cases from QC","og_description":"Download the test cases from QC in Excel Sheet using VBA. Pull Test cases from HP QC in Excel Sheet automatically via Excel Macro.","og_url":"https:\/\/vmlogger.com\/excel\/2013\/09\/download-test-cases-from-qc\/","og_site_name":"Let's excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2013-09-22T16:15:20+00:00","article_modified_time":"2022-08-07T06:04:06+00:00","og_image":[{"width":400,"height":250,"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2013\/09\/Macro-to-download-testcases-from-qc.png","type":"image\/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","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2013\/09\/download-test-cases-from-qc\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2013\/09\/download-test-cases-from-qc\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"HP Quality Center – Excel Macro to Import Test Cases from QC","datePublished":"2013-09-22T16:15:20+00:00","dateModified":"2022-08-07T06:04:06+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2013\/09\/download-test-cases-from-qc\/"},"wordCount":124,"commentCount":51,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2013\/09\/download-test-cases-from-qc\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2013\/09\/Macro-to-download-testcases-from-qc.png","articleSection":["Excel Macro","Excel Macro Tutorial","HP QC"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2013\/09\/download-test-cases-from-qc\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2013\/09\/download-test-cases-from-qc\/","url":"https:\/\/vmlogger.com\/excel\/2013\/09\/download-test-cases-from-qc\/","name":"HP Quality Center - Excel Macro to Import Test Cases from QC - Let's excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2013\/09\/download-test-cases-from-qc\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2013\/09\/download-test-cases-from-qc\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2013\/09\/Macro-to-download-testcases-from-qc.png","datePublished":"2013-09-22T16:15:20+00:00","dateModified":"2022-08-07T06:04:06+00:00","description":"Download the test cases from QC in Excel Sheet using VBA. Pull Test cases from HP QC in Excel Sheet automatically via Excel Macro.","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2013\/09\/download-test-cases-from-qc\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2013\/09\/download-test-cases-from-qc\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2013\/09\/download-test-cases-from-qc\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2013\/09\/Macro-to-download-testcases-from-qc.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2013\/09\/Macro-to-download-testcases-from-qc.png","width":400,"height":250,"caption":"Macro to download test cases from QC"},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2013\/09\/download-test-cases-from-qc\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Macro","item":"https:\/\/vmlogger.com\/excel\/macro\/"},{"@type":"ListItem","position":3,"name":"HP Quality Center – Excel Macro to Import Test Cases from QC"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let's excel in Excel","description":"Let'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":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"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 & currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/x.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\/12184"}],"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=12184"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12184\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media\/242647"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=12184"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=12184"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=12184"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}