how to export crystal report in excel file using vb 6.0

hi

I want to write a code in vb which will directly export crytal report into excel or pdf format.... Also tell me which components should i use?

thnx in advance,
varsha

Do a search here

Hi Varsha,

Use something similar to this one...

Code:

---

With CrystalReport1
                'Your other code like setting report Filename
                'referencing the database and otehr stuff goes here
                'Code for exporting the file to excel format is here
                'set the destination type as file
                .Destination = crptToFile
                'Set the file type to excel
                .PrintFileType = crptExcel50
                'Set the FileName
                .PrintFileName = "C:\MyFile.xls"
                .Action = 0
End With

---