Hi,

It seems that the "Workbooks.Add" method has regressed from 2003 to 2007
when using "HTM" file. Here is the "one line macro" that demonstrates the
same. (The attached HTML open fine from "File/Open" menu or using
the API 'Workbook.Open')


'... Macro Start
Workbooks.Add "c:\temp\abc.htm"
'... Macro End

If I used the 'abc.htm' file (not sure how to attach to this post - hence
typing below) then XL 2007 throws up.

///////////// ABC.HTM//////////////////
<html<body<center
<h1VectorPRO<sup®</sup</h1
<h2Support Resource Priority Report</h2
<table width="90%" border=1
<tr
<td style='color:white;border:.5pt solid
black;background:#4F81BD;'Support Resource</td
<td style='color:white;border:.5pt solid black;background:#4F81BD;' </td
<td style='color:white;border:.5pt solid
black;background:#4F81BD;'Expected Start</td
<td style='color:white;border:.5pt solid
black;background:#4F81BD;'Actual Start</td
<td width="20" style='font-size:7.0pt;color:white;border:.5pt solid
black;background:#4F81BD;'Clr</td
<td style='color:white;border:.5pt solid black;background:#4F81BD;'Task
Manager</td
<td style='color:white;border:.5pt solid black;background:#4F81BD;'Task
Name </td
</tr
<tr
<tdUjjwal Ghosh(Jr)</td
<tdPressure testing of tuyers</td
<td6/16/2007 09:00 AM</td
<td6/16/2007 09:00 AM</td
<td width="20" style='font-size:7.0pt;background:#99CC00;' </td
<tdN ADHIKARY</td
<tdOVERHAULING OF DRILL MACHINE</td
</tr
</table
</center</body</html