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.
I've searched around the forum but can't seem to find a solution to this.
I am outputting my results to an Excel file then adding two non related worksheets to the workbooks final output by creating a field "TAB NAME". At the same time, I want to insert the current date into my filename. I know I can do this separately but cannot figure out how to do both simultaneously. Has anyone found a way to do this? Currently, I'm having to manually change the date in all 3 output tools and I'd like to have it dynamic.
Thanks for the idea, I don't think this will rename my workbook will it? I tried it out and it's adding the date to the tab name but I need to find a way to get the current date into the entire filename.
I may be not understanding the suggestion, please let me know. Appreciate the help.