D
dpenny
I am trying to get Yahoo stk quotes every 5-15 minutes. I have
downloaded a dozen examples, and read several Excel forums. They all
seem to use QueryTables.Add. But this functionality cumulatively adds
querytables to my worksheet - its crazy. I've joined the "XLTRADERS"
group but do not see anything there either.
1) Do I have to detect 1st QT.Add with a global static variable and
thereafter simply refresh?
2) Some sheets have 200-300-400 querytables. How to delete them after
I've been experimenting?
3) Why do I have to have a QT area? Why not fill a string, or VBA
variable that I can then parse?
4) What other methodology is available to get Yahoo quotes (ie without
QTs)?
Thanks for any pointers.
Dick Penny
downloaded a dozen examples, and read several Excel forums. They all
seem to use QueryTables.Add. But this functionality cumulatively adds
querytables to my worksheet - its crazy. I've joined the "XLTRADERS"
group but do not see anything there either.
1) Do I have to detect 1st QT.Add with a global static variable and
thereafter simply refresh?
2) Some sheets have 200-300-400 querytables. How to delete them after
I've been experimenting?
3) Why do I have to have a QT area? Why not fill a string, or VBA
variable that I can then parse?
4) What other methodology is available to get Yahoo quotes (ie without
QTs)?
Thanks for any pointers.
Dick Penny