Predefined macros in .xlsm Excel Outputs

[niklas_greilinger]

Hello,

we are currently building an analytical app where we want to have a .xlsm file as output. Is there a way to predefine some Excel Macros somewhere so that every user that runs the app gets these macros in the excel file when downloading it from the gallery?.

Unfortunately we are not able to get macros in this file.

Thank you!

Niklas

[Luke_C · Accepted solution]

Hi @niklas_greilinger 

You'd want to leverage a template file that the workflow writes to when it runs, this blog might help:

https://community.alteryx.com/t5/Engine-Works/The-Blob-Reporting-That-Isn-t-From-a-Horror-Film/ba-p/...

[MatthewO]

@niklas_greilinger you could potentially accomplish this using the blob tools. These would allow you to copy a template, populate new data, then read and render the updated file in the Gallery. The following article is a useful reference for working with templates.

https://community.alteryx.com/t5/Engine-Works/The-Blob-Reporting-That-Isn-t-From-a-Horror-Film/ba-p/...

[niklas_greilinger]

Hello guys,

thank you for the responses. We used a Solution similar to what @Luke_C  provided. We have a template file and before workflow run we use .bat file to copy the format from the input to the output file. This way we could make it work without using the blob tools.