View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
George J[_3_] George J[_3_] is offline
external usenet poster
 
Posts: 23
Default Should TD be HTMLTableCell?

I am trying to pull data from a webpage, but the number of tables changes
from time to time.
I have found that the table is nested in a cell (< T D tag) and this cell
has a classname so i can work my way through all the TD's in the document
until i get to the appropriate one...

Then how do i get to the table within that TD?

If i have

Dim TDCell as HTMLTableCell
'and find the appropriate cell using
If TDCell.className = "leftmenu_cel" Then

I can't use for each oTable in TDCell otherwise an error comes up so should
TDCell be something other than HTMLTableCell or can someone advise me on how
to extract the table data from here? I've checked that the table doesn't have
any unique classname - that would be too easy

thanks
George