VBA web query question

[atreides]

I'm trying to code up an application in VB to pull information from password protected sites. Say I want to pull my balance from my account or information from my scottrade account, etc...I know you can parse tables in websites with the aid of web query, but I have hit a road block, and would appreciate any thoughts / insights.

 

[tobias elbert]

what's your roadblock? I suppose it's frames or any info wrapped in div tags, as they are not picked up by the web query tool. You will need to extract the source, then use the MS Html parser to build the document tree, and then extract the info from there using e.g. regular expressions or substring functions. More info relating to Html parsing and VB is here, for instances:

http://www.codeguru.com/vb/vb_internet/html/article.php/c4815