Automating Export to Excel from VB code

[nickfatool]

CR8.5Dev, VB6, ODBC

Are the Crystal export functions controllable by VB code?
I have a report that is always exported to Excel, always "7.0 Extended" and Column width always based on Page Header, plus I'd also like to control the resulting file name via code as well.

This would save users a few extra keystrokes, plus ensure it ends up in the format originally intended.

Any clues would be appreciated.

Thanks,

Rob Dexter.

 

[nickfatool]

Using the DRT I found I can access most of this stuff -

Report.ExportOptions.DestinationType = crEDTDiskFile
Report.ExportOptions.FormatType = crEFTExcel70
Report.ExportOptions.DiskFileName = "c:\ExportedCR.xls"

But I cannot find the option to use column widths based on Page Header, are they available?

Any clues would be appreciated.

Thanks,

Rob Dexter.