Report output to Excel

[mhoek74]

I created a simple report and made it look nice in terms of spacing, etc. When running the report and then publishing to Word, of course the formatting is preserved and it looks nice, etc..

However, when choosing the "Analyze it with MS Excel" option, the data is dumped in the standard worksheet view.

Is there any way to dump to excel with some semblance of how it looked in the report view?

Thanks!

 

[IFELSETHEN]

Hi... you will have to create a Excel Macro to format the spreedsheet and then fire the Macro right after the cells get populated.

John

*********************
John Nyhart

http://www.nyhart.com

*********************