Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
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.
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.
