Expand my Community achievements bar.

ReportBuilder being fully integrated with Excel capabilities

Avatar

Level 2

1/24/13

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

Avatar

Level 1

2/21/13

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.

Avatar

Level 1

3/15/13

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