VBA: HTML Table Parsing in Excel

I've been fighting with this for quite a while. Do you have any ideas on how to use DAO or ODBC to parse from line a to b in a given HTML doc?
I'd appreciate your suggestions.
Thanks