Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Internet Queries
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change data source for many queries at once? | Excel Worksheet Functions | |||
Parameters are not allowed in queries that can't be displayed grap | Excel Discussion (Misc queries) | |||
Internet explorer problem | Excel Discussion (Misc queries) | |||
MAKING EXCEL AS HOME PAGE IN INTERNET EXPLORER | Excel Discussion (Misc queries) | |||
Office Apps accessing the Internet | Excel Discussion (Misc queries) |