Stk Quotes:: QueryTable is weird ??
 

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


--
dpenny
------------------------------------------------------------------------
dpenny's Profile: http://www.excelforum.com/member.php...o&userid=19708
View this thread: http://www.excelforum.com/showthread...hreadid=494769

Stk Quotes:: QueryTable is weird ??
 

After establishing a querytable, you should only need to refresh it.

--
Regards,
Tom Ogilvy


"dpenny" wrote in
message ...

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


--
dpenny
------------------------------------------------------------------------
dpenny's Profile:
http://www.excelforum.com/member.php...o&userid=19708
View this thread: http://www.excelforum.com/showthread...hreadid=494769