Exporting to Excel

Exporting to Excel

am 11.10.2007 23:15:14 von bcap

Hi,

I am using the following code to export to Excel:

fn = "QUERYRESULTS.xls"
Response.Buffer = TRUE
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader "Content-Disposition","attachment;filename=" & fn
Response.AddHeader "Content-Disposition","filename=D:\results.xls"

'Response.Buffer = True
'Response.ContentType = "application/word"
'Response.AddHeader "content-disposition", "inline; filename =
ASP_Word_Doc.doc"



However, when it opens in Excel, you will need to modify Excel in
order to be able to print on one page. Is there any way to set the
printing during this process so users do not have to do this each time
they want to print? Or is their another method of doing this that
would work better?

Thank yoU!!!!!!!!!!!!!!!!!!!!!!