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

I have CR 11.5 Enterprise server that runs daily reports with an output format of Excel data only.  Users have to run Macros against the output.  Is it possible to have an Excel macro run against a Crystal report that is run via Enterprise report server?
PCGroupAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mlmccConnect With a Mentor Commented:
There is a 3rd-party tool that can export and allow you to change the filename as you desire.

http://www.milletsoftware.com/Visual_CUT.htm

mlmcc
0
 
MIKESoftware Solutions ConsultantCommented:
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
0
 
Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectCommented:
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
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
mlmccCommented:
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
0
 
PCGroupAuthor Commented:
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
0
 
PCGroupAuthor Commented:
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.
0
 
PCGroupAuthor Commented:
This software in combination with a batch file to run the macro did the trick.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.