Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
VB6 Automatically Export Crystal Report to Excel
- Thread starter kmcclung
- Start date
sodakotahusker
Programmer
- Mar 15, 2001
- 601
What version of Crystal reports are you using?
What you need to do is Export your output to Excel. I know 8.5 has that option.
What you need to do is Export your output to Excel. I know 8.5 has that option.
- Thread starter
- #3
I'm using Crystal v.8 and I figured it out finally.
This is what I did in case it will help others....
crpReports.Destination = crptToFile
crpBMLReports.PrintFileName = "c:\reports\" & sFileName & ".xls"
crpBMLReports.PrintFileType = crptExcel50
crpBMLReports.PrintReport
This is what I did in case it will help others....
crpReports.Destination = crptToFile
crpBMLReports.PrintFileName = "c:\reports\" & sFileName & ".xls"
crpBMLReports.PrintFileType = crptExcel50
crpBMLReports.PrintReport
- Status
Similar threads
- Locked
- Question
