Upgrade Export to Excel to CR9

[Kbuturla]

I have a VB application that puts data into an Access database then uses Crystal to export the data to Excel without viewing it. It is currently using CR7. I need to upgrade it to CR9. I have not been able to figure out how to get the "Select Export File" screen so that the user can change the directory/name of the file.

Any ideas? The upgrade is suppose to be invisible for the user!

 

[Mike Lewis]

Kbuturla,

I don't know VB, so this might be completely off target. However, in Visual Foxpro, I would display a standard Windows File Save dialogue from within my program, and store the name and path of the target file which the user chooses.

Once you have that information, you can store it in the DiskFileName property of the ExportOptions object, set the other properties (for destination type, etc.), then go ahead and call the Export method with a parameter of false.

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[Kbuturla]

Thanks Mike! I did use the windows file save dialog. In my application all I needed to do was to tell it to ShowSave. It is always so simple once you figure it out!