HersheyCruiser
Programmer
I am attempting to create an Excel spreadsheet with multiple worksheets from a Web app using VBScript and XML. The following code within an ASP page successfully create the spreadsheet with the worksheets, but the data which should be loaded from the asp pages specified in the data islands (worksheetsource) is not loading. All the ASP pages are located in the same directory. It appears that when this page is loaded (server side), the worksheetsource parameters are not being resolved. Anyone care to offer some advice?
<%@ Language=VBScript %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "
<html xmlns
="urn:schemas-microsoft-comfficeffice"
xmlns:x="urn:schemas-microsoft-comffice:excel"
xmlns:ss="urn:schemas-microsoft-comffice:spreadsheet"
xmlns="<%
Response.Expires=0 ' prevent caching
Response.Buffer=True
server.ScriptTimeout = 120
Response.ContentType = "application/vnd.ms-excel"
%>
<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 9">
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>Income Totals</x:Name>
<x:WorksheetSource HREF='IncomeTotals.asp'/>
</x:ExcelWorksheet>
<x:ExcelWorksheet>
<x:Name>TaxPayer K1's</x:Name>
<x:WorksheetSource HREF='K1Totals.asp'/>
</x:ExcelWorksheet>
<x:ExcelWorksheet>
<x:Name>Secondary K1's</x:Name>
<x:WorksheetSource HREF='SecondaryTotals.asp'/>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
<x:WindowHeight>8835</x:WindowHeight>
<x:WindowWidth>15180</x:WindowWidth>
<x:WindowTopX>120</x:WindowTopX>
<x:WindowTopY>135</x:WindowTopY>
<xrotectStructure>False</xrotectStructure>
<xrotectWindows>False</xrotectWindows>
</x:ExcelWorkbook>
</xml><![endif]-->
</Head>
</HTML>
<%@ Language=VBScript %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "
<html xmlns
="urn:schemas-microsoft-comfficeffice"xmlns:x="urn:schemas-microsoft-com
ffice:excel"xmlns:ss="urn:schemas-microsoft-com
ffice:spreadsheet"xmlns="<%
Response.Expires=0 ' prevent caching
Response.Buffer=True
server.ScriptTimeout = 120
Response.ContentType = "application/vnd.ms-excel"
%>
<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 9">
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>Income Totals</x:Name>
<x:WorksheetSource HREF='IncomeTotals.asp'/>
</x:ExcelWorksheet>
<x:ExcelWorksheet>
<x:Name>TaxPayer K1's</x:Name>
<x:WorksheetSource HREF='K1Totals.asp'/>
</x:ExcelWorksheet>
<x:ExcelWorksheet>
<x:Name>Secondary K1's</x:Name>
<x:WorksheetSource HREF='SecondaryTotals.asp'/>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
<x:WindowHeight>8835</x:WindowHeight>
<x:WindowWidth>15180</x:WindowWidth>
<x:WindowTopX>120</x:WindowTopX>
<x:WindowTopY>135</x:WindowTopY>
<x
rotectStructure>False</xrotectStructure><x
rotectWindows>False</xrotectWindows></x:ExcelWorkbook>
</xml><![endif]-->
</Head>
</HTML>