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

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