Write to Excel - automated file name basic on logic
I've search the forum but not found my specific question.
I'm writing one file to Excel daily per processer and wonder if there is a way to automatically name the Excel file name with today's date. As i use the same process once a day and need to save the old file i do not want to overwrite previous runs.
The files are all saved in the same folder and i would want to specifiy a condition that the files are named E YYYY-MM-DD, is that possible?