From Version 2019, the VBA code was updated for all shipped reports in accordance with the software migration to .NET. In order to make a similar update for your custom reports, this procedure explains how to enable custom reports by injecting a new VBA function automatically whenever you run a custom report.
-
Open Microsoft Excel on your computer where you want to run your reports.
-
From the sidebar at the left, select Options.
-
In the Excel Options dialog, from the sidebar, select Trust Center.
-
Select Trust Center Settings.
-
In the Trust Center dialog, from the sidebar, select Macro Settings.
-
Under Developer Macro Settings, select the check box Trust access to the VBA project object model.