Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting specific items from large IE table
Trying to pull out specific items from a large IE table (500 rows, 1-4 cols).
Very limited knowledge of HTML is making it harder. Several questions: Examples I have seen here always call the URL. The page I want to read seems to come from a 'Post' Method and the URL is the same regardless of which of thousands of documents you want. I can get to the front page of the doc ok, but then must press a link which ends up with a URL like: http://server.comp.com:8080/appl/requests.do Is it possible to direct XL to the IE window if I am already on the page I want? Next problem is I am not sure I understand tag names well enough to know what to put in the xxx's in the instruction: Set Table = IE.document.getElementsByTagname("xxx") I would like to go to row 483 of the table and extract the last column. The HTML of the page looks something like this for each row/column: <tr style='mso-yfti-irow:483' <td {formatting info} <p class=MsoNormal<span style='{more formatting info}CellContent<o:p</o:p</span</p </td ....td - /td repeats for number of columns on that page What is confusing me is that first style='. Is the 'mso-yfti-irow:483' a tag name I can use to get to an exact row of the table or is the only way to For-Next through all the rows until I get to the one I want to extract? All help greatly appreciated. ed |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting data from large range | Excel Discussion (Misc queries) | |||
Filter a pivot table with large number of unique items in the filterlist | Excel Programming | |||
Pivot Table Top 20 excluding specific items | Excel Discussion (Misc queries) | |||
Pivot Table - Extracting specific data | Excel Worksheet Functions | |||
Pivot Table - Extracting specific data | Excel Worksheet Functions |