LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 53
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Extracting data from large range abe1952 Excel Discussion (Misc queries) 3 November 4th 09 01:05 AM
Filter a pivot table with large number of unique items in the filterlist vjammy Excel Programming 1 September 29th 08 02:31 PM
Pivot Table Top 20 excluding specific items Sarah (OGI) Excel Discussion (Misc queries) 0 November 15th 07 03:31 PM
Pivot Table - Extracting specific data JT Excel Worksheet Functions 2 June 4th 05 04:16 PM
Pivot Table - Extracting specific data JT Excel Worksheet Functions 1 June 3rd 05 06:05 PM


All times are GMT +1. The time now is 08:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"