I am using a macro to add certain functionality to my report. I then publish this report as an HTML document to our Intranet using the Alchemex Add-in PublishSheet. The problem is the macro only runs on completion of the report, so the Sheet that is published does not contain the information created by the macro.
Is it possible to force Alchemex to run the Macro first and then run the Add-in?
Yes, it is possible.
Method
In the Properties window of your report, select the Run Add-Ins field.
Enter the name of your Macro before the Add-in and separate the Macro and Add-in with a ;
Now the Macro will run before running your Add-in.
