| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Web Queries -- unusual problem
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using Web Queries -- unusual problem
You couild import the whole page and then search the result for some
fixed piece of text associated with the table you want: use that to locate the data Tim. "metcab" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using Web Queries -- unusual problem
metcab,
depending on your XL version you can specify which part of the page to load (e.g. tables only) Dm Unseen |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unusual formula | Excel Discussion (Misc queries) | |||
| problem with excel 2003 queries | Excel Discussion (Misc queries) | |||
| Please help with unusual request? | Excel Discussion (Misc queries) | |||
| I'm having an unusual problem with changes in formats in a cell | New Users to Excel | |||
| Microsoft Queries - copying and changing criteria PROBLEM | Excel Programming | |||
Linear Mode
