Business Objects 11.5 Enterprise running Macros against scheduled reports in Excel Format

Not that I'm aware of....

However, I've had "some" success by using Excel TEMPLATES that have the macros built into the Template...whereby this Template is LINKED to and bases it's data on a SET Excel export file.

You may be able to set it up that way, so that your Crystal Report automatically exports into the same set EXCEL EXPORT FILE...so that the EXCEL TEMPLATE..or MAIN FILE will AUTOUPDATE its data, macros and all,...when you open it...

Hope it makes sense...it does work...but you need to have it setup

What are the purposes of the macros?  Users often ask for data to be dumped into Excel only to just perform the same repetitive activities (like macros) against the data on a recurring basis.  This is mostly just because "its the way we've always done it". Why not find out what the macros do and then design a report (or reports) that give them what they actually need?  If they're running macros to "scrub" data, why not do it in the report in the first place?  If the macros create pivot tables, why not design a report with crosstabs?

~Kurt

I agree with Kurt.

I always questioned why users needed data exported to Excel.  Generally it was to present the data in a different way or with some columns removed.  We tried to provide special reports but for a system with 5-600 users special was difficult to respond to since once the door is opened the flodd gates also open.

mlmcc

I agree as well. Unfortunately, the output was difficult to mirror with Crystal.  The end users use the Excel sort and filter functions to manipulate a daily report once the macro is run.  They keep the daily Excel files so I'm not sure the template concept will work but I will give it a go this week.

Thanks

No luck getting the template to work due to the need to name the exported file with a unique name every day.  I will close this question if no one objects.

This software in combination with a batch file to run the macro did the trick.