Hi, I have been wondering whether there is a way to name the workbook based on the dynamic cell value ? Particularly and ideally I would like to have a workbook name which has both: static and dynamic part for example, the workbook name is something_somewhere_date.xlsx
So I would like that date part to be connected to a cell where I just can put =today() /or =CONCATENATE("something_somewhere_"&today()/ and the file everyday generates WORKBOOK's name based on current date.
Tried some VBA but none of them really worked for me. Any help will be appreciated! Thanks!