I have a CR8 report being called through ActiveX control from VB.<br> I need to export this to Excel 2000.<br><br>I am using the following code snippet.<br><br> crptControl.Destination = crptToFile<br>crptControl.PrintFileType = crptExcel50<br>crptControl.PrintFileName = App.Path & "\Customer" & ".XLS"<br>crptControl.ProgressDialog = False<br><br>But it is only printing one page,but I need all the pages. Is there any way to retain the formats as it is.
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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Exporting CR 8 Report to Excel
- Thread starter manibs
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question