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.
tl;dr I can write to multiple tabs and I can assign today's date to output file. Can I do both for the same file so that I end up with 1 file called "Output 2019-11-3.xlsx" with three tabs?
First, I am writing an xlsx file with three tabs. I've successfully used the formula command to add a column called "Sheet Name", checked the "Take File/Name From field" button, selected the Change File Name dropdown, and then used the Block until done tool to write to multiple sheets. This works for as many sheets as I want to add.
The client is requesting the file also have the date stamp in the name, which I've ALSO done by using a formula tool to add a "sheet name" formula of "Outfile "+DateTimeFormat(datetimetoday(),"%Y_%m_%d"). This generates a file named "Outfile 2019-11-3.xlsx. Then I use the the following
I have tried adding a "Block until done" tool at the end of this, but it just generates two files, one with three tabs and one with the date in the name of the field.
Does anyone know if I can create one file with three tabs and the date in the suffix of the name?