Export to excel with sheet name!!

[sparan]

Hi,

Is there a way to rename the excel while exporting data from Crystal Reports XI?

If not is any work arround for this. I will export data into multiple sheets in excel. i need to rename those sheets to custom name.

Thanks in adv.

Sparan.

 

[hilfy]

There is no way to do this directly from Crystal. However, there may be third party tools available that will do this for you. Take a look at

http://www.kenhamady.com/bookmarks.html

for a fairly comprehensive list of the tools that are available.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[IdoMillet]

Have a look at the 3rd-party Crystal Report Managers listed at

http://www.kenhamady.com/bookmarks.html

My Visual CUT software allows you to burst a single report into multiple dynamically named sheets inside a single excel workbook or insert/replace dynamically named sheets inside existing workbook(s).

- Ido

view, email, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com