WebQueries and Access to HTML DOM

[twogeez]

I am just (re)learning VBA having purchased Mr. Excel's book about macros and VBA programming. I am specifically interested in the ability to import web data into a spreadsheet. In experimenting on a very limited basis, I have noted two issues: (1) on some web sites excel is inconsistent in its ability to recognize all tables on the site; one time I go the site it recognizes a particular table, the next time it will not, (2) I am not interested in downloading all information on certain tables excel's browser does recognize, only certain data within the table. Does VBA allow me to parse through the HTML document node tree and extract the specific data (in this case certain data within a table) that I am intereted in? Thank you.