Use .XLS template with Excel Macro
Is it possible to utilize a BIP .xls template that has a macro embedded into it? If so, are there any examples that can be shared with me? I am not sure how to apply formula references in the macro with the first row using the "XDO_?" name manager reference.
The end goal is to have a Macro a user can run on the output of the .xls report file that will do some summarizations based on quantities they enter in the spreadsheet.
Thanks in advance.