Search the source of a website and return only certain info

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
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

kevin.philips

Active Member
Joined
Jan 7, 2003
Messages
364
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
 

Forum statistics

Threads
1,136,990
Messages
5,678,989
Members
419,797
Latest member
ikethegenius

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top