Total Newbie here. I have wrote some simple code but I need help on this
one. I need to import data from a website located at
http://www.2adsdirect.com/SList.asp?vPool=C into an excel worksheet by
clicking on a Button within the worksheet.

The table is updated often and always varies in the number of rows.
Once every two weeks the table starts over.

I need help with the code to import the data without the header rows

I only need the VIN, Mileage, and Sale# columns

I need the data in this order VIN, Mileage, and Sale#

I need for the Mileage to not have the 1000's separator.

Any help on how to start this project of some code samples that may
work for this project would be tremendously appreciated.

Thanks Jody


--
ssjody
------------------------------------------------------------------------
ssjody's Profile: http://www.excelforum.com/member.php...o&userid=33398
View this thread: http://www.excelforum.com/showthread...hreadid=532206