Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Boy, this took some searching... try this info:
http://computerbits.wordpress.com/20...n-web-service/ It looks like you can then create a text file for use by Excel (*.iqy) to query Amazon. Below is an example of an IQY file that is included with Excel. =============== WEB 1 http://moneycentral.msn.com/investor...es.asp?SYMBOL=["QUOTE","Enter stock, fund or other MSN MoneyCentral Investor symbols separated by commas."] =============== I imagine you could construct a similar file to query Amazon, then it looks like you would use "Data/Import External Data/Import Data" to invoke your query. Also, check out: http://www.microsoft.com/mind/0298/corner0298.asp for more info on how to put it all together... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro question | Excel Worksheet Functions | |||
Retrieving SQL data into Excel - Part II | Setting up and Configuration of Excel | |||
Linking the data from one excel to another | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Which Function(s) do I use? | Excel Worksheet Functions |