I'll try this without adding code, I don't have it as I write this.
I picked up Excel VBA to query Yahoo Finance stock prices. I punch the excel button it works fine.
1) wanted to change the VBA to "push down" old results and add new ones
2) didn't like the code & use of cell looping - I know how to modify
3) all of a sudden the "querytable.add......" inserted an extra column into worksheet, of course everything else failed
Q1: any suggestions why
Q2: the help says querytable.add puts a new query into queries collection, are the parameters sort of frozen so I cannot issue a new query
Q3: how can I execute anURL query without adding to the collection, seems very awkward, why can't I just re-execute it
Q4: can I get a query result into a variable rather than a cell or series of cells?
Hmmm, maybe I better post some code.
**** Penny
I picked up Excel VBA to query Yahoo Finance stock prices. I punch the excel button it works fine.
1) wanted to change the VBA to "push down" old results and add new ones
2) didn't like the code & use of cell looping - I know how to modify
3) all of a sudden the "querytable.add......" inserted an extra column into worksheet, of course everything else failed
Q1: any suggestions why
Q2: the help says querytable.add puts a new query into queries collection, are the parameters sort of frozen so I cannot issue a new query
Q3: how can I execute anURL query without adding to the collection, seems very awkward, why can't I just re-execute it
Q4: can I get a query result into a variable rather than a cell or series of cells?
Hmmm, maybe I better post some code.
**** Penny