I am fairly new to VBA and I am learning through trial and error. I
have started experimenting with web queries. I want to import several
tables from the yahoo finance web page. Everything works great, but
when I loop down a list of stocks, there is a problem...

Apparently, a banner ad is sometimes at the top and sometimes it is
not. So depending on if the banner is there or not, my tables are
imported incorrectly because of the webtable line.

Any thoughts to how I can get around this problem?


--
metcab
------------------------------------------------------------------------
metcab's Profile: http://www.excelforum.com/member.php...o&userid=25157
View this thread: http://www.excelforum.com/showthread...hreadid=386561