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
Highlighted
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!

Related Conversations
Automatically name a new worksheet with a date sequence
AnaPistol in Excel on
11 Replies
Assign NAMES to cells based on another cell
Barkster in Excel on
1 Replies
Site name in Windows Explorer
Bas_B in SharePoint on
1 Replies
Tenant Name restrictions in O365
MikeB1903 in Microsoft 365 on
3 Replies