Home

Name workbook based on dynamic cell value

%3CLINGO-SUB%20id%3D%22lingo-sub-458525%22%20slang%3D%22en-US%22%3EName%20workbook%20based%20on%20dynamic%20cell%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-458525%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3CBR%20%2F%3EI%20have%20been%20wondering%20whether%20there%20is%20a%20way%20to%20name%20the%20workbook%20based%20on%20the%20dynamic%20cell%20value%20%3F%3CBR%20%2F%3EParticularly%20and%20ideally%20I%20would%20like%20to%20have%20a%20workbook%20name%20which%20has%20both%3A%20static%20and%20dynamic%20part%3CBR%20%2F%3Efor%20example%2C%20the%20workbook%20name%20is%20something_somewhere_date.xlsx%3CBR%20%2F%3E%3CBR%20%2F%3ESo%20I%20would%20like%20that%20date%20part%20to%20be%20connected%20to%20a%20cell%20where%20I%20just%20can%20put%20%3Dtoday()%26nbsp%3B%20%2For%20%3DCONCATENATE(%22something_somewhere_%22%26amp%3Btoday()%2F%20and%20the%20file%20everyday%20generates%20WORKBOOK's%20name%20based%20on%20current%20date.%3CBR%20%2F%3E%3CBR%20%2F%3ETried%20some%20VBA%20but%20none%20of%20them%20really%20worked%20for%20me.%3CBR%20%2F%3EAny%20help%20will%20be%20appreciated!%3CBR%20%2F%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-458525%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Vardges_Bokhyan
New Contributor

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!