Add latest date while using Output Password Protected XLSX

[tanvir_khan]

Hi all:

I'm using Output Password Protected Excel macro to protect output excel file but this tool takes fixed file name. I need to add current date with file name. Is it possible to set filename dynamically to this tool? Appreciate if anyone let me know please.

Thanks!

[mceleavey · Accepted solution]

Hi @tanvir_khan ,

As with all tools, if you want to make one of the fields dynamic you can simply put the last tool in a macro and feed the sheet name in as a batch parameter to update that field.

Then simply save this as a macro, add it to your workflow to replace the output tool, then set the batch parameter to be the filename (you might want to group by this field first).

M.