[SOLVED] Macro that grabs data from table

I am trying to grab the Item specific data (color, model, mileage, year) from a group of links pasted in the A column (example http://www.ebay.com/itm/Harley-David...m=181746283957), and place the data in subsequent columns. This is what I have so far, but I get an error box "438: Object doesn't support this property or method". I have no idea what this means and what is wrong with my code?? Thanks!!

Please Login or Register  to view this content.

Hello gautum123,

Welcome to the Forum!

The attached workbook walks down the URLs in column "A" starting with "A2" and going down until an empty cell is found. The data from the table is out in the same row as the URL.

There is a button in row 1 to call the macro. This uses a faster and more reliable method of retrieving data. Rather than using Internet Explorer, this macro uses the engine for Internet explorer to access the HTML data. There are actually three macros. The main macro is "GetData". This calls two other macros. First it calls "GetWebDocument" whichs creates an HTML DOM object from the web page's source text. The last macro "GetElemText" is called to parse the text from an HTML element recursively. This allows retrieving a full table row of data with a single call. All text elements are returned as a single string. Each "TD" element in the table is followed by a pipe character "|" to allow the string to split into the appropriate columns.

Module1 Macro Code

Please Login or Register  to view this content.