Export a crystal report to Excel via Visual Foxpro

[bntleahy]

Original Thread:
"I am trying to export a crystal report to Excel via Visual Foxpro. The maximum Excel formattypes allowed in the development documentation is version 5.0. My crystal reports export via Crystal runtime allows an export to excel 8.0 extended. How can I export to Excel 8.0 extended by running crystal reports via VFP code?"

I have followed the guidelines outlined in the article provided by Craig Bersten and am hitting the same exact error I had with my code:
OLE Error Code 0x80070057: The parameter is incorrect

It does not like 27 in the following line:
oExp.FormatType = 27 && crEFTExcel70

oExp.FormatType = 21 works fine but I need the higher version of Excel.

Hopefully you can help me with this. Thanks.

 

[craigber]

And I still have the same answer as the original thread. There are several articles on my web site that show how to integrate Crystal Reports with VFP, including exporting.

Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com

Author, CrysDev: A Developer's Guide to Integrating Crystal Reports"

 

[bntleahy]

The Craig Bernston article was very helpful. I also figured out that my DLL was old. Once this was updated with a later version, the code worked fine.