Thread: HTML INTO EXCEL
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default 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