Hello Ronx, Certainly I can provide the code created by excel. The reason I
am trying to use the excel code within the FP page is that I am trying to
make in more user friendly for the friend I am make this for. If they are
able to just make there changes in excel, which they know how to use saveas
for the sheet in ‘htm’, as their list grows all they have to due is replace
the Song_List.htm to accomplish the change on their webspace.
When I tried to paste the code in I got an error message stating the
following:
Your post is too long. Please reduce the amount of text. (Limit = 30000,
Current=53415
I will remove past comments and paste as much as possible. The rest in the
next post. Hope that works for you.
Here is the Code created from Excel:
<html xmlns
="urn:schemas-microsoft-com
ffice
ffice"
xmlns:x="urn:schemas-microsoft-com
ffice:excel"
xmlns="
http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<meta name=ProgId content=FrontPage.Editor.Document>
<meta name=Generator content="Microsoft FrontPage 5.0">
<link rel=File-List href="SongList_Source2_files/filelist.xml">
<link rel=Edit-Time-Data href="SongList_Source2_files/editdata.mso">
<link rel=OLE-Object-Data href="SongList_Source2_files/oledata.mso">
<!--[if gte mso 9]><xml>
<o
ocumentProperties>
<o:Author>J T</o:Author>
<o:LastAuthor>J T</o:LastAuthor>
<o:Created>2006-04-14T14:31:33Z</o:Created>
<o:LastSaved>2006-04-15T13:09:50Z</o:LastSaved>
<o:Version>11.6360</o:Version>
</o
ocumentProperties>
<o:OfficeDocumentSettings>
<o:RelyOnVML/>
<o:AllowPNG/>
<o
ownloadComponents/>
<o:LocationOfComponents HRef="file:///D:\"/>
</o:OfficeDocumentSettings>
</xml><![endif]-->
<style>
<!--table
{mso-displayed-decimal-separator:"\.";
mso-displayed-thousand-separator:"\,";}
@page
{margin:1.0in .75in 1.0in .75in;
mso-header-margin:.5in;
mso-footer-margin:.5in;}
tr
{mso-height-source:auto;}
col
{mso-width-source:auto;}
br
{mso-data-placement:same-cell;}
..style0
{mso-number-format:General;
text-align:general;
vertical-align:bottom;
white-space:nowrap;
mso-rotate:0;
mso-background-source:auto;
mso-pattern:auto;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
border:none;
mso-protection:locked visible;
mso-style-name:Normal;
mso-style-id:0;}
td
{mso-style-parent:style0;
padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore
adding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
border:none;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:locked visible;
white-space:nowrap;
mso-rotate:0;}
..xl24
{mso-style-parent:style0;
font-family:Arial, sans-serif;
mso-font-charset:0;}
..xl25
{mso-style-parent:style0;
font-size:14.0pt;
font-weight:700;
font-family:Arial, sans-serif;
mso-font-charset:0;
text-align:center;}
..xl26
{mso-style-parent:style0;
font-size:8.0pt;
font-family:Arial, sans-serif;
mso-font-charset:0;}
..xl27
{mso-style-parent:style0;
font-size:8.0pt;
font-weight:700;
font-family:Arial, sans-serif;
mso-font-charset:0;
text-align:left;
vertical-align:top;}
..xl28
{mso-style-parent:style0;
font-size:8.0pt;
font-family:Arial, sans-serif;
mso-font-charset:0;
text-align:left;
vertical-align:top;}
..xl29
{mso-style-parent:style0;
font-size:8.0pt;
font-weight:700;
font-family:Arial, sans-serif;
mso-font-charset:0;
mso-number-format:"Medium Time";
text-align:left;
vertical-align:top;}
..xl30
{mso-style-parent:style0;
font-size:8.0pt;
font-family:Arial, sans-serif;
mso-font-charset:0;
text-align:left;
vertical-align:top;
white-space:normal;}
..xl31
{mso-style-parent:style0;
font-size:8.0pt;
font-family:Arial, sans-serif;
mso-font-charset:0;
white-space:normal;}
-->
</style>
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>Sheet1</x:Name>
<x:WorksheetOptions>
<x
rint>
<x:ValidPrinterInfo/>
<x:HorizontalResolution>-2</x:HorizontalResolution>
<x:VerticalResolution>0</x:VerticalResolution>
</x
rint>
<x:Selected/>
<x
anes>
<x
ane>
<x:Number>3</x:Number>
<x:ActiveRow>10</x:ActiveRow>
<x:ActiveCol>2</x:ActiveCol>
</x
ane>
</x
anes>
<x
rotectContents>False</x
rotectContents>
<x
rotectObjects>False</x
rotectObjects>
<x
rotectScenarios>False</x
rotectScenarios>
</x:WorksheetOptions>
<x
ublishObjects>
<x
ublishObject>
<x:Id>19488</x:Id>
<x
ivID>SongList_19488</x
ivID>
<x:SourceType>SourceRange</x:SourceType>
<x:Source>$A$1:$G$117</x:Source>
<x:HtmlType>HtmlStatic</x:HtmlType>
<x:Location
HRef="C:\Documents and
Settings\Jeff\Desktop\BrookeStone\SongList.htm"/>
</x
ublishObject>
</x
ublishObjects>
</x:ExcelWorksheet>
<x:ExcelWorksheet>
<x:Name>Sheet2</x:Name>
<x:WorksheetOptions>
<x
rotectContents>False</x
rotectContents>
<x
rotectObjects>False</x
rotectObjects>
<x
rotectScenarios>False</x
rotectScenarios>
</x:WorksheetOptions>
</x:ExcelWorksheet>
<x:ExcelWorksheet>
<x:Name>Sheet3</x:Name>
<x:WorksheetOptions>
<x
rotectContents>False</x
rotectContents>
<x
rotectObjects>False</x
rotectObjects>
<x
rotectScenarios>False</x
rotectScenarios>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
<x:WindowHeight>9210</x:WindowHeight>
<x:WindowWidth>10395</x:WindowWidth>
<x:WindowTopX>480</x:WindowTopX>
<x:WindowTopY>90</x:WindowTopY>
<x
rotectStructure>False</x
rotectStructure>
<x
rotectWindows>False</x
rotectWindows>
</x:ExcelWorkbook>
</xml><![endif]-->
</head>
<body link=blue vlink=purple class=xl24>
<table x:str border=0 cellpadding=0 cellspacing=0 width=864
style='border-collapse:
collapse;table-layout:fixed;width:648pt'>
<col class=xl24 width=101 style='mso-width-source:userset;mso-width-alt:3693;
width:76pt'>
<col class=xl24 width=15 style='mso-width-source:userset;mso-width-alt:548;
width:11pt'>
<col class=xl24 width=145 style='mso-width-source:userset;mso-width-alt:5302;
width:109pt'>
<col class=xl24 width=63 style='mso-width-source:userset;mso-width-alt:2304;
width:47pt'>
<col class=xl24 width=102 style='mso-width-source:userset;mso-width-alt:3730;
width:77pt'>
<col class=xl24 width=15 style='mso-width-source:userset;mso-width-alt:548;
width:11pt'>
<col class=xl24 width=167 style='mso-width-source:userset;mso-width-alt:6107;
width:125pt'>
<col class=xl24 width=64 span=4 style='width:48pt'>
<tr class=xl25 height=24 style='height:18.0pt'>
<td height=24 class=xl25 width=101
style='height:18.0pt;width:76pt'>Artist</td>
<td class=xl25 width=15 style='width:11pt'></td>
<td class=xl25 width=145 style='width:109pt'>Song Title</td>
<td class=xl25 width=63 style='width:47pt'></td>
<td class=xl25 width=102 style='width:77pt'>Artist</td>
<td class=xl25 width=15 style='width:11pt'></td>
<td class=xl25 width=167 style='width:125pt'>Song Title</td>
<td class=xl25 width=64 style='width:48pt'></td>
<td class=xl25 width=64 style='width:48pt'></td>
<td class=xl25 width=64 style='width:48pt'></td>
<td class=xl25 width=64 style='width:48pt'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>
<td height=15 class=xl27 style='height:11.25pt'>4 Non-Blondes</td>
<td class=xl27></td>
<td class=xl27>What's Going On</td>
<td rowspan=116 class=xl31 width=63 style='width:47pt'></td>
<td class=xl27>Jennifer Lopez</td>
<td class=xl27></td>
<td class=xl27>Play</td>
<td colspan=4 class=xl26 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>
<td height=15 class=xl27 style='height:11.25pt'>Aerosmith</td>
<td class=xl27></td>
<td class=xl27>Walk This Way</td>
<td class=xl27>Jewel</td>
<td class=xl27></td>
<td class=xl27>Who Will Save Your Soul</td>
<td colspan=2 class=xl27 style='mso-ignore:colspan'></td>
<td colspan=2 class=xl26 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>
<td height=15 class=xl27 style='height:11.25pt'>Alan Jackson</td>
<td class=xl27></td>
<td class=xl27>It's 5:00 Somewhere</td>
<td class=xl27 x:str="Jewel ">Jewel<span style='mso-spacerun:yes'>
</span></td>
<td class=xl27></td>
<td class=xl27>Intuition</td>
<td colspan=4 class=xl26 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>
<td height=15 class=xl27 style='height:11.25pt'>Alana Myles</td>
<td class=xl27></td>
<td class=xl27>Black Velvet</td>
<td class=xl27>Jimmy Buffett</td>
<td class=xl27></td>
<td class=xl27>Margarittaville</td>
<td class=xl27></td>
<td colspan=3 class=xl26 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>
<td height=15 class=xl27 style='height:11.25pt'>Alanis Morrisette</td>
<td class=xl27></td>
<td class=xl27>Hand in Pocket</td>
<td class=xl27>Jimmy Buffett</td>
<td class=xl27></td>
<td class=xl27>Hey Good Looking</td>
<td colspan=4 class=xl26 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>
<td height=15 class=xl27 style='height:11.25pt'>Alanis Morrisette</td>
<td class=xl27></td>
<td class=xl27>Ironic</td>
<td class=xl27>Joan Jett</td>
<td class=xl27></td>
<td class=xl27>I Love Rock & Roll</td>
<td class=xl27></td>
<td colspan=3 class=xl26 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>
<td height=15 class=xl27 style='height:11.25pt'>Allman Brothers</td>
<td class=xl27></td>
<td class=xl27>Southbound</td>
<td class=xl27>Joe Cocker</td>
<td class=xl27></td>
<td class=xl27>Leave Your Hat On</td>
<td class=xl27></td>
<td colspan=3 class=xl26 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>
<td height=15 class=xl27 style='height:11.25pt'>America</td>
<td class=xl27></td>
<td class=xl27>Sister Golden Hair</td>
<td class=xl27>Joe Cocker</td>
<td class=xl27></td>
<td class=xl27>The Letter</td>
<td colspan=4 class=xl26 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>
<td height=15 class=xl27 style='height:11.25pt'>Aretha Franklin</td>
<td class=xl27></td>
<td class=xl27>Respect</td>
<td class=xl27>Joe Cocker</td>
<td class=xl27></td>
<td class=xl27>Feeling Alright</td>
<td colspan=4 class=xl26 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>
<td height=15 class=xl27 style='height:11.25pt'>Aretha Franklin</td>
<td class=xl27></td>
<td class=xl27>Chain of Fools</td>
<td class=xl27>John Denver</td>
<td class=xl27></td>
<td class=xl27>Country Roads</td>
<td colspan=4 class=xl26 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>
<td height=15 class=xl27 style='height:11.25pt'>Avg White Band</td>
<td class=xl27></td>
<td class=xl27>Pick Up Pieces</td>
<td class=xl27>John Mayer</td>
<td class=xl27></td>
<td class=xl27>Why Georgia Why</td>
<td colspan=4 class=xl26 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>
<td height=15 colspan=3 class=xl28
style='height:11.25pt;mso-ignore:colspan'></td>
<td class=xl27>John Mayer</td>
<td class=xl27></td>
<td class=xl27>Bigger Than My Body</td>
<td class=xl27></td>
<td colspan=3 class=xl26 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>
<td height=15 class=xl27 style='height:11.25pt'>Beatles</td>
<td class=xl27></td>
<td class=xl27>Oh Darling</td>
<td class=xl27>John Mellencamp</td>
<td class=xl27></td>
<td class=xl27>Jack and Diane</td>
<td colspan=4 class=xl26 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>
<td height=15 class=xl27 style='height:11.25pt'>Beatles</td>
<td class=xl27></td>
<td class=xl27>Blackbird</td>
<td class=xl28></td>
<td class=xl27></td>
<td class=xl28></td>
<td colspan=4 class=xl26 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>
<td height=15 class=xl27 style='height:11.25pt'>Beatles</td>
<td class=xl27></td>
<td class=xl27>Obladi</td>
<td class=xl27>Katrina & Waves</td>
<td class=xl27></td>
<td class=xl27>Walking on Sunshine</td>
<td class=xl27></td>
<td colspan=3 class=xl26 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>
<td height=15 class=xl27 style='height:11.25pt'>Beatles</td>
<td class=xl27></td>
<td class=xl27 x:str="When I Saw Her Standing ">When I Saw Her Standing<span
style='mso-spacerun:yes'> </span></td>
<td class=xl27 x:str="KC/Sunshine ">KC/Sunshine<span
style='mso-spacerun:yes'> </span></td>
<td class=xl27></td>
<td class=xl27>Get Down Tonight</td>
<td class=xl27></td>
<td colspan=3 class=xl26 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>
<td height=15 class=xl27 style='height:11.25pt'>Beatles</td>
<td class=xl27></td>
<td class=xl27>Norwegian Wood</td>
<td class=xl27>Kylie Minoque</td>
<td class=xl27></td>
<td class=xl27>Outta My Head</td>
<td colspan=4 class=xl26 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>
<td height=15 class=xl27 style='height:11.25pt'>Ben Harper</td>
<td class=xl27></td>
<td class=xl27>Steal My Kisses</td>
<td class=xl27>Led Zeppelin</td>
<td class=xl27></td>
<td class=xl27>Rock & Roll</td>
<td colspan=4 class=xl26 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>
<td height=15 class=xl27 style='height:11.25pt'>Bette Midler</td>
<td class=xl27></td>
<td class=xl27>The Rose</td>
<td class=xl27>Led Zeppelin</td>
<td class=xl27></td>
<td class=xl27>D'yer Maker</td>
<td colspan=4 class=xl26 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>
<td height=15 class=xl27 style='height:11.25pt'>Bill Withers</td>
<td class=xl27></td>
<td class=xl27>Ain't No Sunshine</td>
<td class=xl28></td>
<td class=xl27></td>
<td class=xl28></td>
<td colspan=4 class=xl26 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>
<td height=15 class=xl27 style='height:11.25pt'>Billie Joel</td>
<td class=xl27></td>
<td class=xl27>Piano Man</td>
<td class=xl27>Madonna</td>
<td class=xl27></td>
<td class=xl27>Beautiful Stranger</td>
<td class=xl27></td>
<td colspan=3 class=xl26 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>
<td height=15 class=xl27 style='height:11.25pt'>Billie Joel</td>
<td class=xl27></td>
<td class=xl27>Good Die Young</td>
<td class=xl27>Madonna</td>
<td class=xl27></td>
<td class=xl27>Holiday</td>
<td colspan=4 class=xl26 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>
<td height=15 class=xl27 style='height:11.25pt'>Black Crowes</td>
<td class=xl27></td>
<td class=xl27>Hard to Handle</td>
<td class=xl27>Maroon 5</td>
<td class=xl27></td>
<td class=xl27>This Love</td>
<td colspan=4 class=xl26 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>
<td height=15 class=xl27 style='height:11.25pt'>Blind Melon</td>
<td class=xl27></td>
<td class=xl27>No Rain</td>
<td class=xl27 x:str="Marshall Tucker ">Marshall Tucker<span
style='mso-spacerun:yes'> </span></td>
<td class=xl27></td>
<td class=xl27>Can't You See</td>
<td colspan=4 class=xl26 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>
<td height=15 class=xl27 style='height:11.25pt'>Blondie</td>
<td class=xl27></td>
<td class=xl27>One Way or Another</td>
<td class=xl27 colspan=2 style='mso-ignore:colspan' x:str="Mary C
Carpenter ">Mary
C Carpenter<span style='mso-spacerun:yes'> </span></td>
<td class=xl27>I Feel Lucky</td>
<td colspan=4 class=xl26 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>
<td height=15 class=xl27 style='height:11.25pt'>Blondie</td>
<td class=xl27></td>
<td class=xl27>Tide is High</td>
<td class=xl27>Mary J. Blige</td>
<td class=xl27></td>
<td class=xl27>Family Affiar</td>
<td colspan=4 class=xl26 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>
<td height=15 class=xl27 style='height:11.25pt'>Blues Brothers</td>
<td class=xl27></td>
<td class=xl27>Soul Man</td>
<td class=xl27>Mary J. Blige</td>
<td class=xl27></td>
<td class=xl27>Ooh!</td>
<td colspan=4 class=xl26 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>
<td height=15 class=xl27 style='height:11.25pt'>Blues Cover</td>
<td class=xl27></td>
<td class=xl27>Sweet Home Chicago</td>
<td class=xl27>Matchbox 20</td>
<td class=xl27></td>
<td class=xl29 x:num="0.125">3:00 AM</td>
<td colspan=4 class=xl26 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>
<td height=15 class=xl27 style='height:11.25pt'>Blues Traveler</td>
<td class=xl27></td>
<td class=xl27>Runaround</td>
<td class=xl27 colspan=2 style='mso-ignore:colspan'>Melissa Etheridge</td>
<td class=xl27>Come to My Window</td>
<td class=xl27></td>
<td colspan=3 class=xl26 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>
<td height=15 class=xl27 style='height:11.25pt'>Bob Segar</td>
<td class=xl27></td>
<td class=xl27>Night Moves</td>
<td class=xl30></td>
<td class=xl27></td>
<td class=xl30></td>
<td colspan=4 class=xl26 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>
<td height=15 class=xl27 style='height:11.25pt'>Bob Segar</td>
<td class=xl27></td>
<td class=xl27>Against the Wind</td>
<td class=xl27>Motown</td>
<td class=xl27></td>
<td class=xl27>Ain't Too Proud to Beg</td>
<td class=xl27></td>
<td colspan=3 class=xl26 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>
<td height=15 class=xl27 style='height:11.25pt'>Bob Segar</td>
<td class=xl27></td>
<td class=xl27>Turn the Page</td>
<td class=xl27>Motown</td>
<td class=xl27></td>
<td class=xl27>Dancing In the Streets</td>
<td colspan=2 class=xl27 style='mso-ignore:colspan'></td>
<td colspan=2 class=xl26 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>
<td height=15 class=xl27 style='height:11.25pt'>Bob Segar</td>
<td class=xl27></td>
<td class=xl27>Ramblin/Gamblin Man</td>
<td class=xl27>Motown</td>
<td class=xl27></td>
<td class=xl27>Rescue Me</td>
<td colspan=4 class=xl26 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>
<td height=15 class=xl27 style='height:11.25pt'>Bonnie Raitt</td>
<td class=xl27></td>
<td class=xl27>Something Talk About</td>
<td class=xl27>Motown</td>
<td class=xl27></td>
<td class=xl27>Good Love</td>
<td colspan=4 class=xl26 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>
<td height=15 class=xl27 style='height:11.25pt'>Bonnie Raitt</td>
<td class=xl27></td>
<td class=xl27>Not<span style='mso-spacerun:yes'> </span>the Only One</td>
<td class=xl27>Motown</td>
<td class=xl27></td>
<td class=xl27>Grapevine</td>
<td colspan=4 class=xl26 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>
<td height=15 class=xl27 style='height:11.25pt'>Bonnie Raitt</td>
<td class=xl27></td>
<td class=xl27>Love Me Like a Man</td>
<td class=xl28></td>
<td class=xl27></td>
<td class=xl28></td>
<td colspan=4 class=xl26 style='mso-ignore:colspan'></td>
</tr>
<tr class=xl26 height=15 style='height:11.25pt'>