PAG 1.- aquiestalaconsulta.asp
-----------------------------------------------------------------------
<html>
<head><title>mi pagina</title>
<script language=javascript>
function exportar(opcion){
var nuevatabla = ""
var tabla = document.getElementById('inicioexcel').innerHTML;
document.getElementById('tabla').value = tabla;
document.getElementById('accion').value = opcion;
document.frm.submit();
}
</script>
</head>
<body>
<div id=inicioexcel>
<tabla>datos generados por la consulta</tabla>
</div>
<a href=javascript
:exportar(1)><img src="img/excel.gif border=0 width=22 height=22></a>
<form id="frm" name="frm" action="excel.asp" method="post" target="paso">
<input type="hidden" id="tabla" name="tabla">
</form>
</body></html>
PAG 2.- excel.asp
-----------------------------------------------------------------------
<html>
<head>
<title>EXPORTAR A EXCEL</title>
<%
sub exportarexcel()
Response.buffer = true
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader "Content-Disposition", "filename=respaldo.xls;"
end sub
%>
<script language=javascript >
function cerrar(){
var ventana = window.self;
ventana.opener = window.self;
// ventana.close();
}
</script>
</head>
<body onload=cerrar();>
<%
tabla = request("tabla")
response.Write(tabla)
if tabla <> "" then
if tabla <> "0" then
exportarexcel
end if
end if
%>
</body>
</html>