Hi ya all!

I'm trying to export a Report to excel, but I get this error and found no answers in other places. I'm Using VB6 SP6 and CR8.5.

Here's the code...

Private Sub ExportToExcel()
Dim oExportOptions As CRAXDRT.ExportOptions

Set oExportOptions = crxReport.ExportOptions
With oExportOptions
.FormatType = crEFTExcel80
.DestinationType = crEDTApplication
End With

crxReport.Export False

End Sub

Any help will be really appreciated.


Carlos Antonio