Need help Downloading Crystal Report

[james.lim]

Due to the nature of my job, I need to download crystal report on a daily basis.

Is there anyone who know how to automatically download crystal report and save it as an excel file. :think:

Appreciate if someone can help me :bow:

thx you

[Imdabaum]

Most Crystal Reports come with an Export button. How do you view your Crystal Report? I'm not extremely familiar with Crystal Reports but recent project re-assignments has put me in charge of one. In your Crystal Report viewer is there an envelope with a red arrow going into it? If so Select that option and then drill down till you get to Excel as the doc type.

[james.lim]

thanks for you reply. Would actually like to know if there is a way to make use of VBA to automatically download the Crystal Report on a daily basis?

[Brandtrock]

Try Ken Hamaday's site (http://www.kenhamady.com/bookmarks.html). Under report managers there is a freeware that may be of use to you.

Regards,