Predefined macros in .xlsm Excel Outputs

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

Output

Accepted answers

Luke_C

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/970280

All comments

Luke_C

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/970280

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/970280

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703