HTML Objects
 

I am cutting from an HTML page in a browser what is mostly tabular data that
I want in Excel.

However, what comes with it when I paste it into my Excel sheet is also all
of the HTML controls like check boxes and command buttons.

I've spent a fair amount of time researching what collection I might need to
traverse to delete all of them, but so far no luck in finding the right one.

Can anyone shed any light on what collection those might be in in the Excel
list of objects?

HTML Objects
 

Hi George,
shapes collection

See my page on Shapes
http://www.mvps.org/dmcritchie/excel/shapes.htm
---
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

"George Stevenson" wrote in message ...
I am cutting from an HTML page in a browser what is mostly tabular data that
I want in Excel.

However, what comes with it when I paste it into my Excel sheet is also all
of the HTML controls like check boxes and command buttons.

I've spent a fair amount of time researching what collection I might need to
traverse to delete all of them, but so far no luck in finding the right one.

Can anyone shed any light on what collection those might be in in the Excel
list of objects?

HTML Objects
 

Hi George, (email only)
In addition to what I posted since you are working with HTML
you will likely need to make use of the TRIMALL macro in
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
you might also be interested in my page on collections
http://www.mvps.org/dmcritchie/excel/collections.htm

and the reply I posted of course shapes.htm
---
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

"George Stevenson" wrote in message ...
I am cutting from an HTML page in a browser what is mostly tabular data that
I want in Excel.

However, what comes with it when I paste it into my Excel sheet is also all
of the HTML controls like check boxes and command buttons.

I've spent a fair amount of time researching what collection I might need to
traverse to delete all of them, but so far no luck in finding the right one.

Can anyone shed any light on what collection those might be in in the Excel
list of objects?