Hi George, 1.You can use "Find" method to search the particular value in a Excel sheet. 2.Within that loop you can assign one variable to count the Row, Using that count you can get the Next column value
On Sun, Mar 30, 2014 at 8:31 AM, george <[email protected]> wrote: > Hi Guys, > > Please advise what to do in this case. > The following script opens my excel workbook, searches the string and > highlights the value: > ______________________________________________________ > > Set myxl = createobject("excel.application") > myxl.Workbooks.Open "C:\book1.xlsx" > myxl.Application.Visible = true > set mysheet = myxl.ActiveWorkbook.Worksheets("Sheet1") > > With mysheet.UsedRange > > For each search_data in mysheet.UsedRange > > If search_data="11" then > > search_data.Interior.ColorIndex = 40 > > End If > Next > End With > > 'Save the Workbook > 'myxl.ActiveWorkbook.Save > 'Close the Workbook > myxl.ActiveWorkbook.Close > 'Close Excel > myxl.Application.Quit > Set mysheet =nothing > Set myxl = nothing > > _________________________________ > > > This works, but I want the value from next column: > > xlsx example: > > A B > > 01 usa > 02 canada > > > I would like to highlight and *maybe Print *"usa" as versus highlighting > 01 only. > > please send me the code > > thanks in advance > > > -- > -- > You received this message because you are subscribed to the Google > "QTP - HP Quick Test Professional - Automated Software Testing" > group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/MercuryQTP?hl=en > > --- > You received this message because you are subscribed to the Google Groups > "QTP - HP Quick Test Professional - Automated Software Testing" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- -- You received this message because you are subscribed to the Google "QTP - HP Quick Test Professional - Automated Software Testing" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/MercuryQTP?hl=en --- You received this message because you are subscribed to the Google Groups "QTP - HP Quick Test Professional - Automated Software Testing" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
