Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HTML INTO EXCEL
Hi all,
I have performed an SPSS syntax (for a multinomial logistic regression model) that produces 100 html files each containing 2 tables one for the classification and the other for the parameter estimates.I want to save these files in an excel format ,but, actually i do not want to save the whole tables in the files, but just certain cells(cells containing the VALUES OF THE parameter estimates and the overall percentage of correct classification). Is this possible in excel using a certain macro? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
HTML INTO EXCEL
You could use automation to load each of the files into IE, then extract the
table information from the HTML Document Object Model. Google for "automate IE" in this group and you should get some examples. Tim "A.A.A" wrote in message ... Hi all, I have performed an SPSS syntax (for a multinomial logistic regression model) that produces 100 html files each containing 2 tables one for the classification and the other for the parameter estimates.I want to save these files in an excel format ,but, actually i do not want to save the whole tables in the files, but just certain cells(cells containing the VALUES OF THE parameter estimates and the overall percentage of correct classification). Is this possible in excel using a certain macro? Thanks |
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) | |||
Excel-Html | Excel Discussion (Misc queries) | |||
Excel to HTML | Excel Programming | |||
HTML in Excel VBA | Excel Programming |