how to grab data from a website into an excel spreadsheet?

Question

Hello, I would like to know if someone has a solution for the following :

I am maling price quotes in an excel spreadsheet. To do this, I have to type in the part number on a webpage

http://support.startrac.com/index.cfm?fuseaction=cart.SearchByPartNumber

For example 800-4026, which gives me the description and the price for that part. I than have to switch to my excel sheet , copy/paste the info, and repeat all this for all subsequent parts. Finally I have then my complete pricequote in my excel sheet, with VAT, conversion rates etc. And this process is getting a bit cumbersome. So I was thinking: If this webpage can grab that data from a remote website, why cannot I do that straight from an excel sheet with some kind of formula. So I would enter let's say 800-4026 in cell A1 and in cell A2 I would have something a function something like =GETPRICE(http://support.startrac.com/index.cfm?fuseaction=cart.SearchByPartNumber, A1), which would pop the price directly into A2. That would be great!!! Now is that possible? If so, how? Notice that my development skills are VERY limited, so if I have to develop code, please explain in step, by step detail how I should go about this.

Thanks a lot in advance for any help/ideas.

Answer 1

Hi,

Thank you for your message but you wrote it in a french forum.

Please, reedit a new messsage in french.

---

Argy