Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Programming > Html in Excel
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
TOM TOM is offline
external usenet poster
  
Posts: 47
Default Html in Excel
Hello All,

Below is my html file, which I got using saveas(
htmltable!) html file is like what I want but if I will
open it in Excel I will not get backcolor and all
formatting it shows in Html.

So please tell me how I can achieve this ?




<title</title
<STYLE TYPE="text/css"
<!--
..htmldwC5B{;background-color:#ffffff; width:100%}
..htmldwC5D{}
..htmldwC5E{;background-color:#ffffff;
width:100%;COLOR:#000000;FONT:12pt "MS Sans Serif", sans-
serif;FONT-STYLE:normal;FONT-WEIGHT:bold;TEXT-
DECORATION:none;TEXT-ALIGN:left;BORDER-STYLE:solid}
..htmldwC5F{;background-color:#d4d0c8;
width:100%;COLOR:#000000;FONT:8pt "MS Sans Serif", sans-
serif;FONT-STYLE:normal;FONT-WEIGHT:normal;TEXT-
DECORATION:none;TEXT-ALIGN:left;BORDER-STYLE:solid}
..htmldwC60{;background-color:#fffacd;
width:100%;COLOR:#000000;FONT:8pt "MS Sans Serif", sans-
serif;FONT-STYLE:normal;FONT-WEIGHT:normal;TEXT-
DECORATION:none;TEXT-ALIGN:left;BORDER-STYLE:solid}
..htmldwC65{;COLOR:#000000;FONT:8pt "MS Sans Serif", sans-
serif;FONT-STYLE:normal;FONT-WEIGHT:normal;TEXT-
DECORATION:none;TEXT-ALIGN:left;BORDER-STYLE:solid}
..htmldwC6D{;COLOR:#000000;FONT:8pt "MS Sans Serif", sans-
serif;FONT-STYLE:normal;FONT-WEIGHT:normal;TEXT-
DECORATION:none;TEXT-ALIGN:center;BORDER-STYLE:solid}
..htmldwC79{;background-color:#fffacd;
width:100%;COLOR:#000000;FONT:8pt "MS Sans Serif", sans-
serif;FONT-STYLE:normal;FONT-WEIGHT:normal;TEXT-
DECORATION:none;TEXT-ALIGN:center;BORDER-STYLE:solid}
..htmldwC7F{;background-color:#fffacd;
width:100%;COLOR:#000000;FONT:8pt "MS Sans Serif", sans-
serif;FONT-STYLE:normal;FONT-WEIGHT:normal;TEXT-
DECORATION:none;TEXT-ALIGN:right;BORDER-STYLE:solid}
..htmldwC84{;background-color:#ffdab9;
width:100%;COLOR:#000000;FONT:8pt "MS Sans Serif", sans-
serif;FONT-STYLE:normal;FONT-WEIGHT:normal;TEXT-
DECORATION:none;TEXT-ALIGN:left;BORDER-STYLE:solid}
..htmldwC85{;background-color:#ffdab9;
width:100%;COLOR:#000000;FONT:8pt "MS Sans Serif", sans-
serif;FONT-STYLE:normal;FONT-WEIGHT:normal;TEXT-
DECORATION:none;TEXT-ALIGN:center;BORDER-STYLE:solid}
..htmldwC8B{;background-color:#ffdab9;
width:100%;COLOR:#000000;FONT:8pt "MS Sans Serif", sans-
serif;FONT-STYLE:normal;FONT-WEIGHT:normal;TEXT-
DECORATION:none;TEXT-ALIGN:right;BORDER-STYLE:solid}
..htmldwC90{;background-color:#d4d0c8;
width:100%;COLOR:#000000;FONT:8pt "MS Sans Serif", sans-
serif;FONT-STYLE:normal;FONT-WEIGHT:bold;TEXT-
DECORATION:none;TEXT-ALIGN:center;BORDER-STYLE:solid}
..htmldwC92{;background-color:#d4d0c8;
width:100%;COLOR:#000000;FONT:8pt "MS Sans Serif", sans-
serif;FONT-STYLE:normal;FONT-WEIGHT:bold;TEXT-
DECORATION:none;TEXT-ALIGN:right;BORDER-STYLE:solid}
--
</STYLE

<TABLE CLASS=htmldwC5B BORDER=1 WIDTH=693

<TR<TD NOWRAP WIDTH=88<TD NOWRAP WIDTH=11<TD NOWRAP
WIDTH=22<TD NOWRAP WIDTH=22<TD NOWRAP WIDTH=33<TD
NOWRAP WIDTH=33<TD NOWRAP WIDTH=66<TD NOWRAP
WIDTH=77<TD NOWRAP WIDTH=22<TD NOWRAP WIDTH=22<TD
NOWRAP WIDTH=77<TD NOWRAP WIDTH=88<TD NOWRAP
WIDTH=55<TD NOWRAP WIDTH=66<TD NOWRAP WIDTH=11</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC5E COLSPAN=9ROSIBLU COST
SHEET (INTERNAL DOCUMENT)</TD








<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC5FCollection</TD
<TD NOWRAP CLASS=htmldwC60 COLSPAN=42700-2899WRAP</TD



</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC5FStyle #</TD
<TD NOWRAP CLASS=htmldwC60 COLSPAN=4HARISSH</TD



</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC5FDescription</TD
<TD NOWRAP CLASS=htmldwC60 COLSPAN=4Harish Test
Style</TD



</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC65Finished DWT</TD
<TD NOWRAP CLASS=htmldwC60 COLSPAN=44.0000</TD



</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC65Production</TD
<TD NOWRAP CLASS=htmldwC60 COLSPAN=4D</TD



</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC65 COLSPAN=2Components</TD

<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC65 COLSPAN=4Casting/Metal</TD



<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC65 COLSPAN=2Casting # /
Metal</TD

<TD NOWRAP CLASS=htmldwC6D ALIGN=center COLSPAN=2</TD

<TD NOWRAP CLASS=htmldwC65</TD
<TD NOWRAP CLASS=htmldwC65Metal</TD
<TD NOWRAP CLASS=htmldwC65Dwt.</TD
<TD NOWRAP CLASS=htmldwC65Vendor</TD
<TD NOWRAP CLASS=htmldwC6D ALIGN=center
COLSPAN=2Qty.</TD

<TD NOWRAP CLASS=htmldwC65Metal Cost/Dwt.</TD
<TD NOWRAP CLASS=htmldwC65Casting Cost</TD
<TD NOWRAP CLASS=htmldwC65Labor Cost</TD
<TD NOWRAP CLASS=htmldwC65Total Cost</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC60 COLSPAN=210056TCST</TD

<TD NOWRAP CLASS=htmldwC79 ALIGN=center COLSPAN=2</TD

<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center10KT</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center1.4000</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center
COLSPAN=21.0</TD

<TD NOWRAP CLASS=htmldwC7F ALIGN=right10.21</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right23.74</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right12.00</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right35.74</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC84 COLSPAN=210056TCST</TD

<TD NOWRAP CLASS=htmldwC85 ALIGN=center COLSPAN=2</TD

<TD NOWRAP CLASS=htmldwC85 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center10KT</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center1.3000</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center
COLSPAN=21.0</TD

<TD NOWRAP CLASS=htmldwC8B ALIGN=right9.48</TD
<TD NOWRAP CLASS=htmldwC8B ALIGN=right23.74</TD
<TD NOWRAP CLASS=htmldwC8B ALIGN=right12.00</TD
<TD NOWRAP CLASS=htmldwC8B ALIGN=right35.74</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC90 ALIGN=centerTotal ct.</TD
<TD NOWRAP CLASS=htmldwC90 ALIGN=center
COLSPAN=22</TD

<TD</TD
<TD NOWRAP CLASS=htmldwC92 ALIGN=right47.48</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC92 ALIGN=right71.48</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC65 COLSPAN=4Stones</TD



<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC65 COLSPAN=2Stone Type</TD

<TD NOWRAP CLASS=htmldwC6D ALIGN=center
COLSPAN=2Shape</TD

<TD NOWRAP CLASS=htmldwC65Cut</TD
<TD NOWRAP CLASS=htmldwC65Size</TD
<TD NOWRAP CLASS=htmldwC65Clr./Qlty.</TD
<TD NOWRAP CLASS=htmldwC65Vendor</TD
<TD NOWRAP CLASS=htmldwC6D ALIGN=center
COLSPAN=2Qty.</TD

<TD NOWRAP CLASS=htmldwC65Stone Cost/Ct</TD
<TD NOWRAP CLASS=htmldwC65Total Gem Cst</TD
<TD NOWRAP CLASS=htmldwC65Setting Cost</TD
<TD NOWRAP CLASS=htmldwC65Ttl Setting Cst</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC60 COLSPAN=2DIAM</TD

<TD NOWRAP CLASS=htmldwC79 ALIGN=center
COLSPAN=2EM</TD

<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center.22</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=centerIF/NA</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center
COLSPAN=22.0</TD

<TD NOWRAP CLASS=htmldwC7F ALIGN=right694.95</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right2779.80</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right9.00</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right2788.80</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC84 COLSPAN=2CRRB</TD

<TD NOWRAP CLASS=htmldwC85 ALIGN=center
COLSPAN=2BEAD</TD

<TD NOWRAP CLASS=htmldwC85 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center0.0100</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=centerCLAR/NA</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center
COLSPAN=21.0</TD

<TD NOWRAP CLASS=htmldwC8B ALIGN=right2.00</TD
<TD NOWRAP CLASS=htmldwC8B ALIGN=right2779.80</TD
<TD NOWRAP CLASS=htmldwC8B ALIGN=right9.00</TD
<TD NOWRAP CLASS=htmldwC8B ALIGN=right2788.80</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC90 ALIGN=centerTotal ct.</TD
<TD NOWRAP CLASS=htmldwC90 ALIGN=center
COLSPAN=23</TD

<TD</TD
<TD NOWRAP CLASS=htmldwC92 ALIGN=right5559.6</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC92 ALIGN=right5577.6</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC65 COLSPAN=4Finding</TD



<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC65 COLSPAN=2Finding
Desc./Style #</TD

<TD NOWRAP CLASS=htmldwC6D ALIGN=center COLSPAN=2</TD

<TD NOWRAP CLASS=htmldwC65Metal</TD
<TD NOWRAP CLASS=htmldwC65Dwt.</TD
<TD NOWRAP CLASS=htmldwC65Size</TD
<TD NOWRAP CLASS=htmldwC65Vendor</TD
<TD NOWRAP CLASS=htmldwC6D ALIGN=center
COLSPAN=2Qty.</TD

<TD NOWRAP CLASS=htmldwC65Component Cost</TD
<TD NOWRAP CLASS=htmldwC65</TD
<TD NOWRAP CLASS=htmldwC65Misc. Cost</TD
<TD NOWRAP CLASS=htmldwC65Total Cost</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC60 COLSPAN=2</TD

<TD NOWRAP CLASS=htmldwC79 ALIGN=center COLSPAN=2</TD

<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center
COLSPAN=20</TD

<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC90 ALIGN=centerTotal ct.</TD
<TD NOWRAP CLASS=htmldwC90 ALIGN=center
COLSPAN=20</TD

<TD</TD
<TD NOWRAP CLASS=htmldwC92 ALIGN=right0</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC92 ALIGN=right0</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC65 COLSPAN=4Production</TD



<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC65 COLSPAN=2Prod. Steps</TD

<TD NOWRAP CLASS=htmldwC6D ALIGN=center COLSPAN=2</TD

<TD NOWRAP CLASS=htmldwC65Vendor/Contractor</TD
<TD NOWRAP CLASS=htmldwC65</TD
<TD NOWRAP CLASS=htmldwC65</TD
<TD NOWRAP CLASS=htmldwC65Req. of Vendor</TD
<TD NOWRAP CLASS=htmldwC6D ALIGN=center COLSPAN=2</TD

<TD NOWRAP CLASS=htmldwC65</TD
<TD NOWRAP CLASS=htmldwC65</TD
<TD NOWRAP CLASS=htmldwC65</TD
<TD NOWRAP CLASS=htmldwC65Total Cost</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC84 COLSPAN=2Assembly</TD

<TD NOWRAP CLASS=htmldwC85 ALIGN=center COLSPAN=2</TD

<TD NOWRAP CLASS=htmldwC85 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center
COLSPAN=20</TD

<TD NOWRAP CLASS=htmldwC8B ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC8B ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC8B ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC8B ALIGN=right0</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC60 COLSPAN=2Polishing</TD

<TD NOWRAP CLASS=htmldwC79 ALIGN=center COLSPAN=2</TD

<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center
COLSPAN=20</TD

<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC84 COLSPAN=2Final
Finishing</TD

<TD NOWRAP CLASS=htmldwC85 ALIGN=center COLSPAN=2</TD

<TD NOWRAP CLASS=htmldwC85 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center
COLSPAN=20</TD

<TD NOWRAP CLASS=htmldwC8B ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC8B ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC8B ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC8B ALIGN=right0</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC60 COLSPAN=2Packaging</TD

<TD NOWRAP CLASS=htmldwC79 ALIGN=center COLSPAN=2</TD

<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center
COLSPAN=20</TD

<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC84 COLSPAN=2Shipping</TD

<TD NOWRAP CLASS=htmldwC85 ALIGN=center COLSPAN=2</TD

<TD NOWRAP CLASS=htmldwC85 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC85 ALIGN=center
COLSPAN=20</TD

<TD NOWRAP CLASS=htmldwC8B ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC8B ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC8B ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC8B ALIGN=right0</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC90 ALIGN=centerTotal ct.</TD
<TD NOWRAP CLASS=htmldwC90 ALIGN=center COLSPAN=2</TD

<TD</TD
<TD NOWRAP CLASS=htmldwC92 ALIGN=right</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC92 ALIGN=right0</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC65 COLSPAN=4For Finished
Goods</TD



<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC65 COLSPAN=2Style #</TD

<TD NOWRAP CLASS=htmldwC6D ALIGN=center COLSPAN=2</TD

<TD NOWRAP CLASS=htmldwC65Vendor Order Style #</TD
<TD NOWRAP CLASS=htmldwC65</TD
<TD NOWRAP CLASS=htmldwC65</TD
<TD NOWRAP CLASS=htmldwC65Vendor</TD
<TD NOWRAP CLASS=htmldwC6D ALIGN=center COLSPAN=2</TD

<TD NOWRAP CLASS=htmldwC65</TD
<TD NOWRAP CLASS=htmldwC65</TD
<TD NOWRAP CLASS=htmldwC65</TD
<TD NOWRAP CLASS=htmldwC65Total Cost</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC60 COLSPAN=2</TD

<TD NOWRAP CLASS=htmldwC79 ALIGN=center COLSPAN=2</TD

<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center
COLSPAN=20</TD

<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC90 ALIGN=centerTotal ct.</TD
<TD NOWRAP CLASS=htmldwC90 ALIGN=center COLSPAN=2</TD

<TD</TD
<TD NOWRAP CLASS=htmldwC92 ALIGN=right</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC92 ALIGN=right0</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC65 COLSPAN=3Notes : General
Instruction</TD


<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC60 COLSPAN=14Special
Instructions</TD













<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD NOWRAP CLASS=htmldwC65Gemstone PO date :</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC65Ttl Gem Cost</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC65Ttl Mfg Cost</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC65Protect. M/U %</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center0</TD
<TD NOWRAP CLASS=htmldwC65RBF Prot'd</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC65Wh.sale M/U %</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center0</TD
<TD NOWRAP CLASS=htmldwC65Wholesale</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD</TD
</TR
<TR CLASS=htmldwC5D
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD</TD
<TD NOWRAP CLASS=htmldwC65Retail M/U %</TD
<TD NOWRAP CLASS=htmldwC79 ALIGN=center0</TD
<TD NOWRAP CLASS=htmldwC65MSRP</TD
<TD NOWRAP CLASS=htmldwC7F ALIGN=right0</TD
<TD</TD
</TR
</TABLE

Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 208
Default Html in Excel
Hi Tom,
Your message is far too long for anyone to look through - give a
shorter version??
Also, can't you just open the original Excel file? Why save excel as
HTML then open the HTML in Excel??!
regards
Paul

"TOM" wrote in message ...
Hello All,

Below is my html file, which I got using saveas(
htmltable!) html file is like what I want but if I will
open it in Excel I will not get backcolor and all
formatting it shows in Html.

So please tell me how I can achieve this ?

Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Hybrid Mode Hybrid Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Stop excel from processing HTML? IE paste raw html. nick Excel Discussion (Misc queries) 2 April 21st 23 05:12 PM
Excel-Html puiuluipui Excel Discussion (Misc queries) 0 May 18th 10 05:09 PM
HTML in Excel TBewley Excel Discussion (Misc queries) 0 February 20th 09 11:13 PM
html and excel Tim Excel Discussion (Misc queries) 0 January 13th 07 12:54 PM
HTML in Excel VBA Sheela Excel Programming 0 August 22nd 03 05:43 AM


All times are GMT +1. The time now is 11:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement