copying website info into cells

**detlion1643** · 11-23-2009, 11:24 AM

Right now i am manually copying and pasting information from a website into excel columns.

Considering the amount of products (10,000+), and time this involves i was wondering if it's even possible to automate this.

EX) to get all HP monitors, or all dlink networking gear
it would pull the manufacturing numbers based on brand and category

the only problem i forsee is breaking up the products by category and brand, as they are search filters you can add on the website.

If this is not even possible in excel, sorry for wasting time.

**detlion1643** · 11-23-2009, 12:45 PM

i found some sample code that i have been trying to decipher and cater to my neds, although i am a little confused and lost.

Please Login or Register  to view this content.

The problem is, i don't want to search anything in a search box. I first click on the product category and the click the product brand. From there i need to get the manufacturing part #'s of the products into excel, and the span multiple pages.

**detlion1643** · 11-23-2009, 01:49 PM

i got it so it opens the website with the correct search parameters. I am now viewing the source code in excel and i know i can search the tags. The problem is that what i need is not contained in a tag.

td class="productlist-even" style="text-align: center; width: 150px; white-space: nowrap;">CM770A#B1K</td>

i am looking to get the "CM770A#B1K" and insert that into column C starting at row 2. It will need to get all the results in that source and then move to page 2 and do the same thing.

EDIT: i got it to go to the different pages, so it might be easier if looping through the source and pulling the info out could be written as a function.
that way, everytime i nagivate to a page, i just call the function. it would cut down on so much coding because of my search strings.

**detlion1643** · 11-23-2009, 05:33 PM

still have not solved my problem yet... although the page loads fine. everything i have tried to get the source code to an external file, or to another worksheet in excel has not worked. if i could at least do that, i would be able to manipulate the source code better.
ex)

Please Login or Register  to view this content.

i would first want to display 997-3113-00 in cell C2 and then 997-3156-00LF in C3, etc. and would check through the entire source. I have been scratching my head and scouring the net for what seems like forever on this.