Retrieve information from website using VBA

If anyone could help me, it would be much appreciated. But I am looking to build a macro that will look up an item number that I type in excel, and do a search on a website like Amazon, or any other retailer, and return information from that search such an item price, specs, etc.

I am not even 100% sure that this is possible, but I figured to ask if anyone had an idea.

Thanks Leith,

Here is one of the examples of a site that I would use...

www.lowes.com

I would search an item number of an item, example " RTW4640YQ"

In this case, an appliance pops up. I would want to bring in the price ($399 in this case)

How would I write this?

Is this what you are wanting to do?

Please Login or Register  to view this content.

Or try this one, much faster..

Please Login or Register  to view this content.

Thanks for the response.

I think this is kind of on the right path, but what I am looking to do is have a column of about 10-15 item numbers, and when I run the macro, it will go retrieve the prices of those items from Lowes website.

Like this?

Please Login or Register  to view this content.

Oh wow! Sorry... I just realized, the site redirects unless you select your zipcode. That is why the price didnt show up and lord knows why or how i missed that. . . Let me try that again

Is there a way to have the prices appear in the same file as the item numbers? So if i have a list of items in column C, then the prices would appear in column D?

Im not sure how i would get around that redirect using that method. . This might work though, needs some cleaning but it should get the job done:

Please Login or Register  to view this content.

Thanks alot for your help.

I am getting an error at the beginning of it though, at the "dim LOIE" part. It is saying "User defined type not defined".

Nevermind...I didnt have internet controls enabled. Fixed it.

When I run it however, it is just pasting in all the text from page of the search result. Also, right now, it is set to only search that same item. If i had a list of 5 items, how would i edit the search?

Ideally, what I would like the end result to be is to have a column that has 5 items, which could change, and when the macro is run, it will bring in the current prices that lowes as on their website, and have those prices displayed in the column next to the item numbers

When you paste the code, you need to delete the part = "washer", and un-comment the application.inputbox line next to it. Should look like this: part = application.inputbox("What are we searching for at Lowes today? "Lowes Search",Type:=2)

As for the text, it sounds like the function is not getting called. . Which is weird because i tested it before i posted. Let me look real quick..