Change File Names To A User Defined New Name

I have attached a file. I am trying to get a code that will rename parts of a filename to a specific new filename, but KEEPING certain parts of the original file name.

Below is a picture of the userform:

1.png


Below is a picture of an example of what I am trying to achieve:

2.png

Can you please open the attached Excel file and help me to get the code for the "Process Change" button?

Thank you!

You could use this syntax

Please Login or Register  to view this content.

That does not allow keeping parts of the old file name as per the example.

Originally Posted by chin67326

That does not allow keeping parts of the old file name as per the example.

Why would it not? All you need to do is include the parts you want to keep in the new file name. Don't let the trees block your view of the forest.

Think this will do the job for you.

Please Login or Register  to view this content.

Originally Posted by JLGWhiz

Why would it not? All you need to do is include the parts you want to keep in the new file name. Don't let the trees block your view of the forest.

Thanks for your reply. It is impossible to timely input the parts I want to keep in the new file name because some folders, which contain files I want to rename, have over 3,500 files in them. So it is a quite huge forest of trees.

Therefore I am looking for a code than can take into consideration whatever I input in the "Enter Existing Text" textbox (which in the example is 'ThePowerToolsForFarmingVegetables'), and then the code should be written to keep whatever is left in that file name when it processes the renaming. For example in the first file above, '- Corner House Garage' is kept after the renaming is done. Consider the file name as split into two parts, a prefix and suffix. Essentially I want to rename the prefix but keep the suffix. In the same example above '- Corner House Garage' will be the suffix.

Missed my post ?

Originally Posted by bakerman2

Missed my post ?

Hi bakerman2, sorry the weirdest thing happened. After I typed my reply to JLGWhiz, then your post appeared. I have been testing it and it works quite good and does what I want! Thank you. However when I downloaded your version and initialized, no buttons are present on the userform and it looks like the below. No buttons appeared even after I started typing in the textboxes:

thatimage.png

In design mode however I note you combined the select folder button and process change button into a single button. Is it possible to have the two buttons separate as per the original image above? i.e. a command button to select a folder, then I will enter the details in the two textboxes, after which I will click the process change button (i.e. command button 2).

Thanks!

Originally Posted by chin67326

Hi bakerman2, sorry the weirdest thing happened. After I typed my reply to JLGWhiz, then your post appeared. I have been testing it and it works quite good and does what I want! Thank you. However when I downloaded your version and initialized, no buttons are present on the userform and it looks like the below. No buttons appeared even after I started typing in the textboxes:

Attachment 603965

In design mode however I note you combined the select folder button and process change button into a single button. Is it possible to have the two buttons separate as per the original image above? i.e. a command button to select a folder, then I will enter the details in the two textboxes, after which I will click the process change button (i.e. command button 2).

Thanks!

bakerman2 , nevermind, I did some tweaks to your code and have what I want. Thanks again; you have been repped.

I wrote it this way to make sure both textboxes are filled before starting the code.
But tweaking it to your liking is of course your prerogative.

Anyway, glad to help and thanks for rep+.

Originally Posted by bakerman2

I wrote it this way to make sure both textboxes are filled before starting the code.
But tweaking it to your liking is of course your prerogative.

Anyway, glad to help and thanks for rep+.

Sure no worries.

You are welcome and thanks again

Hi bakerman2, I would like to ask for your assistance rather than starting a new thread. I forgot to mention that some of the filenames that will be renamed contain Chinese characters and when I run the code I get the below run-time error 52/debug error. I believe Chinese characters are Unicode? Is there a tweak that you can do to your code that can tell the code to ignore or avoid the Chinese characters but still execute the renaming process? Maybe a tweak that can ignore the debug error?

By the way, the Chinese characters will be inputted in Textbox 1 ('Enter Existing Text' textbox) and there will be no Chinese characters in the remainder of the filename that we will be keeping.

I would be keen to know what you can do in this scenario.


31.12.181.png

Thanks!

Any clue how to fix the above?

I did some searching and found the below code. I think I need a function inputted that can eliminate all non-alphanumeric characters from the filenames. However I do not know how to integrate the below in the code. Any clue anyone?

Please Login or Register  to view this content.