I figured out how to enable the Programmatic access. 3.1 sees the Macro, 3.0 still doesn’t for some reason (even after enabling the Programmatic access in Excel). This is somewhat frustrating
Is 3.1 mature enough to put into production for automated reporting? I know it’s still a beta license and I probably won’t be able to swap over to the Enterprise license until GA in the first week of April, but I don’t have that long (our Microstrategy DW goes away 4/1) and I’m being pushed to automate as much as possible.
I understand - I really only need to use the Export Wizard then, as it accomplishes both tasks.
I used the 3.1 Beta, and I’m getting an error message when I get to the Macro select (3.0 doesn’t display any error messages when it doesn’t show the macros). The error is:
“Programmatic access to Visual Basic Project is not trusted. Please enable this feature in Excel in order to allow the execution of macros.”
In Excel I’ve enabled all macros, as you outlined in your blog post. Is there something else I need to enable?
Debbie Peabody wrote:
In the example I was showing how to use both the expert wizard and select to file activities with xlsm files. In order to fire a macro you have to use the export wizard activity. This activity always uses a saved template so you will need to go throught the wizard, set when to fire the macros and save to disk. If you only want to fire a macro then write a query that does not return any rows.
RE: not seeing the macros, I am not sure what is occuring there. I would try our 3.1 Beta. If you still have the issue in our Beta please send me a copy of your file and we can take a look.