Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from processing HTML? IE paste raw html. | Excel Discussion (Misc queries) | |||
Deleting Objects all at once - (copied HTML to excel) | Excel Discussion (Misc queries) | |||
Prevoiusly posted message: Unable to remove objects pasted into Excel from HTML grid | Excel Worksheet Functions | |||
Deleting HTML form objects? | Excel Discussion (Misc queries) | |||
Unable to remove objects pasted into Excel from HTML grid | Excel Worksheet Functions |