Output to xlsm

[michael_carrico]

We would like to have the ability to overwrite sheets in macro-enabled Excel workbooks.  Several of our scorecarding templates leverage macros for Excel events, protection, and interaction, and the ability to directly overwrite data in these workbooks would be a huge benefit of  using Alteryx.

[levell_x_dunn]

I agree with Michael, the only way I have been able to get a work around was to export to an excel file and then have the xlsm read from that excel file, pretty long about way to get it done

[Inactive User]

Has this been figured out?

[patrick_digan]

Yep! It was added as part of 10.5 under additional changes: 

• Microsoft Excel macro-enabled (Read & Write – .xlsm)

Here is how i setup a quick example: