vba export data only to excel

[Eprice]

Hello
I am trying to export crystal reports data to excel but there are probably at least 20 extra columns when I use my code to run the export. When I manually export to excel using the format 'MS Excel 97-2000 (Data Only)' it works perfect. I don't know the correct way to code the data only part. This is what I have.

Dim CrApp As Object
Set CrApp = New Craxdrt.Application
Dim CrRep As Craxdrt.Report
Set CrRep = CrApp.OpenReport("N:\Job Log\AC-JOBLOG PRINTED.rpt")
With CrRep.ExportOptions
.DestinationType = crEDTDiskFile
.FormatType = crEFTExcel80
.DiskFileName = "N:\Job Log\AC-JOBLOG PRINTED REPORTS.xls"
End With
CrRep.Export (False)
Set CrRep = Nothing
Set CrApp = Nothing

Does anybody know what I should put in .FormatType to get data only so it exports correctly. Thanks
Lisa

 

[kenhamady]

I think the format type is crEFTExcel80Tabular

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

http://www.kenhamady.com/

 

[Eprice]

Not getting an answer, I started with the list index number and found tha 6 did what I wnated with FormatType = 6.
Thanks
Lisa

 

[kenhamady]

I believe that 6 is tab separated, according to this link:

http://devlibrary.businessobjects.c...oc/doc/rdcsdk_com_doc/RDC_ObjectModel303.html

If it does what you want then you are all set.


Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

http://www.kenhamady.com/