This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.