W
wyndouglas
I've set up a workbook to track basketball statistics for a Yaho
fantasy league. I've been trying to get the workbook to link to Yahoo'
stat tables but I'm running into a problem.
I use the "Import External Data" -> "New Web Query" and then navigat
to the page I want to link. I check the box to green for the specifi
table I want on each page. However, sometimes when I refresh, a
adjacent table is imported instead of the one I intended.
I'm a little worried that Yahoo may put some dummy tables into the cod
as it generates dynamically (I think) to prevent precisely what I tryin
to do. However, I'm not knowledgable as to whether or not the We
Queries work that way, ie how does Excel know WHICH table on a page t
import after you check the box to green?
My thought is that if the method of importing I use saves the tabl
info as a relative value (checking the green box points to the 5t
table in the blahblahblah.html for instance, but a dummy table i
inserted dynamically to make it sometimes point to the table ABOVE th
one I originally pointed to) then is there a way to absolutely identif
the table in some other importing/programming method?
If anyone needs to look at the html or specific web pages to know, le
me know.
Thanks for any ideas you may have
fantasy league. I've been trying to get the workbook to link to Yahoo'
stat tables but I'm running into a problem.
I use the "Import External Data" -> "New Web Query" and then navigat
to the page I want to link. I check the box to green for the specifi
table I want on each page. However, sometimes when I refresh, a
adjacent table is imported instead of the one I intended.
I'm a little worried that Yahoo may put some dummy tables into the cod
as it generates dynamically (I think) to prevent precisely what I tryin
to do. However, I'm not knowledgable as to whether or not the We
Queries work that way, ie how does Excel know WHICH table on a page t
import after you check the box to green?
My thought is that if the method of importing I use saves the tabl
info as a relative value (checking the green box points to the 5t
table in the blahblahblah.html for instance, but a dummy table i
inserted dynamically to make it sometimes point to the table ABOVE th
one I originally pointed to) then is there a way to absolutely identif
the table in some other importing/programming method?
If anyone needs to look at the html or specific web pages to know, le
me know.
Thanks for any ideas you may have