HTML Objects

[George Stevenson]

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?

 

[David McRitchie]

Hi George,
shapes collection

See my page on Shapes
http://www.mvps.org/dmcritchie/excel/shapes.htm

 

[David McRitchie]

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