Search the source of a website and return only certain info

[cordeirodiego]

I have a macro that searches the pricegrabber.com website for various products from a list and just opens the pages. What I would like is this:

1. Create a list in excel of different products to search - DONE
2. Create a macro that seaches for each product and grabs the source or content of each page from pricegrabber - DONE

here is the tricky part

3. Have the macro search trough the source code or page content for different sellers that I like and if the item is listed as "in stock" then right the price listed on the page for that item on to the column corresponding to that seller on the excel list.

So the excel list should look like this:

PRODUCT SELLER1 SELLER2 SELLER3 SELLER4
-------------------------------------------------------------------
product1 $459.95 $438.62 N/A N/A
product2 $705.82 N/A $756.45 N/A
product3 N/A $256.43 N/A $199.86

PLEASE SOMEONE HELP

 

[kevin.philips]

You should do a search for XMLHttp and invoke the object through VBA, I have some code to grab source information from Yahoo Stock Quotes if you want me to ost it let me know,

Regards

Kevin

 

[cordeirodiego]

Idon't know how to use that command can you teach me?