I am importing data from the internet but just selecting a small number
of tables from the internet pages (Some share price data and analysts
estimates). My problem is that every so often the selceted tables are
de-selected and either no tables or random tables are pulled through
instead. I have not been able to write a macro to pull through just the
selected tables. Has anyone else had this problem? Is there a way round
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 this
example
Earnings Est
Revenue Est
It is the latter 2 that keep being lost/reset
Thanks for any help on this
--
psmall
------------------------------------------------------------------------
psmall's Profile:
http://www.excelforum.com/member.php...o&userid=27647
View this thread:
http://www.excelforum.com/showthread...hreadid=471688