Hi there,

I'm trying to import the roster from this page
http://cbs.sportsline.com/collegebas...eams/roster/AF

The problem I have is all I want is the information the Heading "NO" to
the final entry cel "Fort Worth, TX".

I've tried a number of times to do it, but am not sure which Yellow
Arrows to select. I've tried numerous combinations with none returning
the proper data, in some cases, any data.

Can somebody please help me out??

Thanks so much!


--
BrandNewToThis
------------------------------------------------------------------------
BrandNewToThis's Profile: http://www.excelforum.com/member.php...o&userid=28439
View this thread: http://www.excelforum.com/showthread...hreadid=482546

Hi ...,
I don't know what yellow arrows you are talking about, but since
it doesn't sound like you are doing this with macro anyway, I'll
provide a manual suggestion. (The programming newsgroup
is where people ask for help with macros)

Open the HTML file with Internet Explorer as your browser,
select the table as best you can, and paste into an Excel
worksheet. You will have picked up a lot of shape objects
which can be deleted by selecting all cells on worksheet,
then Ctrl+G, Special (button), objects, Del key or Edit, delete.
Then remove the extraneous rows and columns.

You can use a macro to delete all of the shape objects on a sheet
at once without a loop and without any need to first make a selection
within the worksheet..
See the delShapesOnSht macro with
code posted by Dave Peterson
Shapes
http://www.mvps.org/dmcritchie/excel/shapes.htm

To fix the column widths, widen all of the columns then double click
on a column demarcation with all of the cells still selected to adjust
the column widths down.

You can open the web page in Excel with File, Open but it's
not as easy to work with as if you do your selection and then
copy and paste to the worksheet. One advantage may be that
the widths of the columns are more likely to be correct.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"BrandNewToThis" <BrandNewToThis.1y1tza_1131236402.2389@excelforu m-nospam.com wrote
I'm trying to import the roster from this page
http://cbs.sportsline.com/collegebas...eams/roster/AF

The problem I have is all I want is the information the Heading "NO" to
the final entry cel "Fort Worth, TX".

I've tried a number of times to do it, but am not sure which Yellow
Arrows to select. I've tried numerous combinations with none returning
the proper data, in some cases, any data.

Can somebody please help me out??