Change workbook name to same as host folder name.

[GedSalter]

Hi all,


Is there a way to automatically change workbook name dependent on which folder its in?

If say the host folder is called "2019" and the workbook is called "test.xlsm". When "test.xlsm" workbook is placed into the "2019" folder the workbook then changes name to 2019.xlsm?

regards

Ged

 

[James006]

Hi,

What is going to happen to the second file stored in the folder ?

Do you plan to have as many folders as individual files ?

 

[GedSalter]

there wont be a second file, im hoping. I was hoping the file automatically changes its name so only 1 file is present

 

[James006]

If your rule is 1 File = 1 Folder ...

you can Move or Copy your file from Folder1 to Folder2 and then rename it ...

 

[GedSalter]

using a vba?

 

[James006]

Yes ... with VBA ...

see link:

https://www.encodedna.com/2014/02/copy-move-files-from-one-folder-to-another-using-excel-vba.htm

Hope this will help

 

[James006]

and then to Rename ... simply

<code>Name OldFileName As NewfileName</code>

Hope this will help