I used VB6 to export the Crystal Report into Excel, but I got my export in Excel as a picture. There no columns or rows. Which code should I use to export the Crystal into real excel format?
Here is code that I used:
.DestinationType = crEDTDiskFile
.FormatType = crEFTExcel97
.DiskFileName = gsExpFilePath
.ExcelUseConstantColumnWidth = True
'.ExcelConstantColumnWidth = 50
.ExcelExportAllPages = True