+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: VB Scripting/Descriptive Programming (https://www.learnqtp.com/forums/Forum-VB-Scripting-Descriptive-Programming)
+--- Thread: need help with excel object (/Thread-need-help-with-excel-object)
need help with excel object - kundan2612@gmail.com - 03-06-2013
Hi there,
I need little help with an issue.Please find the description mentioned below: (Please refer the screenshot)
1) I have a global datasheet with some values(shown in screenshot)
2) I have a local excel workbook with multiple sheets.(shown in screenshot)
3) There are 3 columns in Global datasheet i.e. Comp_Name,New_Column and Value
4) I need to search the first Comp_Name value i.e. LaunchandLogin in the local workbook i.e. I have to seach which local workbook sheet matches with Comp_Name and have to go into that sheet.
5) Once I am into that sheet I have to transpose the New_Column and Values into it. (Param1 and Yes in this case)
6) I have to keep transposing the data but when I find CRELG1 as Comp_Name...then I have to repeat steps 4 and 5.(Plz refer screenshot)
If any one can provide the code for this,I will really be very grateful.
Thanks and Regards
Kundan
RE: need help with excel object - vinod123 - 03-08-2013
i did not find screenshot