Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web Query
Hi,
I use to get the web data on button click with the codes provided by Dave. No i would like to modify the codes as per users request. If the innertext value of 4th column of HTML table is already available in the extracted sheet then code should skip the row & go for next row of html table something like if ......... then exit for else. For ready reference some of the codes provinding here For Each mRow In mTable.Rows iCol = 0 For Each mCell In mRow.Cells rBase.Offset(iRow, iCol).Value = mCell.innerText iCol = iCol + 1 Next iRow = iRow + 1 End If Next If mCell.innertext value already available then exit for -- Thanks, Vikram P. Dhemare |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Problem with .Background Query option of ODBC Query | Excel Programming |