ReportBuilder being fully integrated with Excel capabilities

niladri9

24-01-2013

Can we get ReportBuilder being fully integrated with Excel capabilities meaning supporting VBA/macros as well? .xlsm format cannot be saved/scheduled currently and thats a huge challenge right now for us because most of the reports/dashboards we have uses some or the other macro/VBA programming.

3 Comments (3 New)
3 Comments

bige938007

21-02-2013

You are correct that .XLSM-formatted (macro-enabled) workbooks cannot be scheduled through ReportBuilder. This is due to massive security risk to our scheduling servers by running macros/VBA scripts. However, you should be able to save .XLSM files locally with ReportBuilder requests embedded within. Let me/ClientCare know if that does not work for you.

bige938007

15-03-2013

In terms of VBA/macro support for ReportBuilder requests, the following Exchange Idea is currently in progress and will be released in the near future: http://ideas.omniture.com/t5/Adobe-Idea-Exchange-for-Omniture/Reportbuilder-Add-VBA-suppor t-to-trigger-data-refresh-from-a/idc-p/9407#M5396

bige938007

21-03-2013