cordeirodiego
Board Regular
- Joined
- Jun 3, 2004
- Messages
- 60
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
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