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!
Solved! Go to 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.