Export Crystal report to Excel using VBA

[Mattyb33]

I have 6 Crystal reports which I want to export to Excel. I know how to do this, but my question is can I do it using VBA for Excel??

Any help would be greatly appreciated!!

Thanks,
Matt

 

[SkipVought]

hi,

If you're doing it from Excel, it would be IMPORTING from CR.

You realise that importing is just data, with no formatting. So why not just run the same query in Excel, using MS Query? No real need for CR, unless I am missing something.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Mattyb33]

Yes sorry, I mean importing to Excel from the Crystal reports.

I have 6 Crystal reports set up, most of them in a cross tab format. They're emailed to my inbox (Microsoft Outlook) every week in Crystal format. So I was wondering if it was possible in VBA for Excel to either import them from Crystal or from the Crystal reports I receive in the emails.

 

[kray4660]

I have been watching this thread and now I am really lost. So you have the report definitions e-mailed to you not the output of the reports? If you are mailing the report definitons to you, that will not do you any good unless you have a way to run the reports (Crystal reports or a viewer).

If the reports are setup to output to Excel, then that would be a different issue.

Please clarify.

Thanks.

 

[Mattyb33]

Apolgies for not being clearer. The output of the reports are emailed to me in Crystal format.

 

[SkipVought]

If it were me, since this is an on-going issue, I would move heaven and earth to get the orignial source, as the cross tab is NOT a good structure to do data analysis and reporting in Excel.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[kray4660]

I do not know of any way of extracting the data from a report exported in Crystal format (there might be a way, but someone would have to know how the file is structured). It would be better to export the reports in a different format that Excel at least could read directly.

 

[Mattyb33]

Ok I think I'll have to export them from Crystal manually into a format Excel can understand as you say. Thanks for your help!!!