Deleting HTML form elements from worksheet

[tgryffyn]

I posted this to the Excel forum on UtterAccess already since I happene
to already be there, forgive the "crossposting".

I'm wondering if anyone knows how to delete HTML form elements when yo
copy and paste from an HTML page into Excel?

I see them if I add a watch in VB for "Application.Sheets.Item1" (fo
the first sheet) listed as things like HTMLCheckbox1, HTMLOption1
HTMLSelect1, HTMLSubmit1 (or 2 or 3 if there are multiple, etc).


I can see them in the application.sheets list, but I can't select the
on an actual sheet and just delete them. Deleting the cells aroun
them doesn't work either.

I'm not even sure how to delete them programatically since they're no
really a collection and I'm not sure how to just parse through all th
properties, methods, objects, etc of an object checking the TYPE to se
if it matched one of these types.

It's more of an annoyance than anything else, but when I can't figur
something out I like to keep digging until I do.

Thanks in advance for any thoughts or suggestions you may have.

-T

 

[Dave Peterson]

Are there any other shapes that you want to keep?

If no:

Edit|goto|special|check Objects
hit the delete key.

If there are some shapes you want to keep:
show the drawing toolbar
(View|Toolbars|Check drawing)

Then use that arrow to lasso the ones you don't want. Then hit the delete key.

(it may take a few lassos worth to get them all.)