Import Internet Info

[Shadowsgone]

Hello all. I need some help making some code in excels vba. I dont know any of the internet commands in vba and so im asking you guys for help. what i need the program to do is go to a website that i have in the first cell. This is one of the urls http://www.newegg.com/Product/Produc...82E16812270101 ( i only need it to run once i can do the rest ok). When it goes to that url i need it find all the information under specifications. you dont even have to make the code all i really need is what statement i would use to search for the stuff under specifications.

any help is greatly appreciated.
Thank you

[Leith Ross]

Hello Shadowsgone,

That website looks familiar. Didn't I help write a macro for you to look up products on that site?

EDIT: I did help you on March 31, 2010. You posted the question here.

[Shadowsgone]

Yes you did lol. But this time i need to specs and not the urls. I really do need to find a book on Excel VBA code or somethin lol

[Leith Ross]

Hello Shadowsgone,

Okay, here is the basic code to retrieve the specifications on the web page. You will need to add code to loop that returns the text for each cell (label) in the specifications.

Please Login or Register  to view this content.

[Shadowsgone]

in the part where you said add additional code here thats where im going to make it so it adds the data to the cells on the spreadsheet.

[Leith Ross]

Hello Shadowsgone,

That's correct. The loop returns all the specification data.

For Example:

• Model
  Brand BYTECC
  Model USB2-10AB-W
  Spec
  Type USB 2.0
  Length 10 ft.
  Color White
  Connector Number 2
  Terminal Gender M-M

Where "Model" is TblData(0)

[Shadowsgone]

ok good cause i did that but for some reason i get this error:
run-time error '1004' method 'range' of object '_global' failed

i went to debug it and its on this line:

Please Login or Register  to view this content.

so i changed it to say

Please Login or Register  to view this content.

i still got the same error. i took the .value out just because i had a problem with that before and that didnt change anything. im wondering if i change the code to read like this:

Please Login or Register  to view this content.

if that would work. ill give that a try and a few other ways if you can think of a better way please let me, i really love the help and im learning quite a bit. Thank you Ross

[Leith Ross]

Hello Shadowsgone,

All element collections in HTML are zero based (the first element is zero). Range rows and columns are one based (first element starts at one). You need to add 1 to I so the range will work. I have made the correction in bold.

Please Login or Register  to view this content.

[Shadowsgone]

Thats it!!!! Thank you so much for the help again Ross.

[Shadowsgone]

Hey Ross, I need some more help with the code you helped me on. I found out that some products have more than one table with the class name of "specification" but only one of those tables has an id name of "pcraSpecs". saddly i dont know how to change the code for this.
this is the area i think needs the only change:

Please Login or Register  to view this content.

if you need the rest let me know ok

[Leith Ross]

Hello shadowsgone,

This should do it. It looks for DIV tag with the ID "pcraSpecs". The table cells are then listed on the worksheet. I had tried doing this in the beginning and problems. After working with the code more I understand where I went wrong.

Please Login or Register  to view this content.

[Shadowsgone]

ok i see what you did. thanks you for the help and sorry if i gave you any trouble.

[Leith Ross]

Hello shadowsgone,

You weren't any trouble. I learned some new things about the IE object model. Thanks.

[Shadowsgone]

I learned a lot of new things also so Thank you Ross