P
psmall
I am importing data from the internet but just selecting a small numbe
of tables from the internet pages (Some share price data and analyst
estimates). My problem is that every so often the selceted tables ar
de-selected and either no tables or random tables are pulled throug
instead. I have not been able to write a macro to pull through just th
selected tables. Has anyone else had this problem? Is there a way roun
this.
Example page imported would be:
http://uk.finance.yahoo.com/q/ae?s=LLY
Do a Data, Import External Data, New Web Query
Tables selected are Company Name: Eli Lilly & Co. (LLY) in thi
example
Earnings Est
Revenue Est
It is the latter 2 that keep being lost/reset
Thanks for any help on thi
of tables from the internet pages (Some share price data and analyst
estimates). My problem is that every so often the selceted tables ar
de-selected and either no tables or random tables are pulled throug
instead. I have not been able to write a macro to pull through just th
selected tables. Has anyone else had this problem? Is there a way roun
this.
Example page imported would be:
http://uk.finance.yahoo.com/q/ae?s=LLY
Do a Data, Import External Data, New Web Query
Tables selected are Company Name: Eli Lilly & Co. (LLY) in thi
example
Earnings Est
Revenue Est
It is the latter 2 that keep being lost/reset
Thanks for any help on thi