Hello all,

I have a web application that creates reports.

I need to export a report to .xls file and save the file to the client computer.

at the moment the file gets saved onto the server...

Code:
Fname = "C:\Reports\Excel\Report.xls"
crDiskFileDestinationOptions.DiskFileName = Fname
With myReport.ExportOptions
    .DestinationOptions = crDiskFileDestinationOptions
    .ExportDestinationType = ExportDestinationType.DiskFile
    .ExportFormatType = ExportFormatType.RichText
End With
myReport.Export()
how would i change my code to solve my problem?

thanx,
Tom