Output Data to Multiple Files in .xlsm

[aba]

Hi Everyone,

Hoping I can get some help from someone please. I've got a workflow that essentially reads in records from a file, executes some data processing in terms of grouping and then outputs the finished output. Problem is, I'm trying to output into a specific .xlsm template as a journal file for upload. I can successfully output into the template with an named range in excel (anything other than this and Alteryx complains about the formula in the template), but challenge is creating multiple files (i.e. multiple template journals) for each group of transactions. 

When I try to use a field in the data for multiple outputs, it says I need to specify a sheet for the output.

Can anyone please help?

aba

[jdminton]

@aba this was your first mention of .xlsm. All you need to do is switch the output format from .xlsx to .xlsm. Since the rename was from an existing Excel file, the replace in the formula tool is also needed to change the name going in to an .xlsm file as well. See attached.