LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22
Default Retrieving Amazon product data to excel, namely books!

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro question Chris Excel Worksheet Functions 12 July 7th 06 01:23 AM
Retrieving SQL data into Excel - Part II Rob Setting up and Configuration of Excel 0 June 29th 06 10:47 PM
Linking the data from one excel to another mrbalaje Excel Discussion (Misc queries) 2 June 13th 05 10:44 AM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM
Which Function(s) do I use? LB Excel Worksheet Functions 3 January 6th 05 02:53 AM


All times are GMT +1. The time now is 05:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"