I have a folder names as "19_Dec" This folder contains a excel sheet name as "ResultsFile_19_Dec.xls"
This excel contains column name as "Category TestID Description TestStatus"
Now in another folder that is "folder" I have different excel files which is named as similar to Category name (ResultsFile_19_Dec.xls eg. TestCat1,TestCat2 etc)
And the excel files placed in "Folder" contains columns "TestCaseID TestDescription Execute"
which are similar to column name in"ResultsFile_19_Dec.xls"
Now I need to create a VB script that will check following:
1. Check column name "Category" from "ResultsFile_19_Dec.xls" for ex "TestCat1" the test status is "fail" now for this fail check the "Execute" column from "TestCat1.xls" and change No to Yes
2. Similarly for Category TestCat2 , search for TestCat2.xls in "folder" and for all the fail , convert "execute" to pass