-
April 9th, 2005, 11:46 PM
#1
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
-
April 11th, 2005, 08:58 AM
#2
Re: how to export crystal report in excel file using vb 6.0
I'd rather be wakeboarding...
-
April 11th, 2005, 10:05 AM
#3
Re: how to export crystal report in excel file using vb 6.0
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|