Rename Excel files on base of current file name

**ali84pk** · 06-09-2010, 05:33 AM

Dear Experts,

I need help regarding renaming excel files. sorry if someone had already asked this question.

I have 1600+ workbooks which i had to rename them, on base of existing names. Condition for renaming is one particular word. If that word exists in that file name, then
it should add my new word at the starting of current file name

For example that particular word is "VIP".If this word exists in file name then that file should be renamed by adding word "ACTIVE"

e.g:
if file name is : European VIP USD Rates updated as on 23.03.2010
Then
it should be renamed as: ACTIVE European VIP USD Rates updated as on 23.03.2010

similarly if file name has word "INT" then it should add word "INTERNATIONAL" in the starting of that file.
e.g:
Today's updated INT Rates as on 28.01.2010
it should be renamed as: INTERNATIONAL Today's updated INT Rates as on 28.01.2010.

Thanks in advance.

**Marcol** · 06-09-2010, 07:41 AM

Try this with copies of your files in a test folder.

If you are happy it does what you need, run it on the real thing .....

Please Login or Register  to view this content.

Call the sub using

Please Login or Register  to view this content.

and again with

Please Login or Register  to view this content.

IF ALL IS WELL WITH YOUR TEST FOLDER

Change the path Const to the real thing and run

Please Login or Register  to view this content.

Hope this helps.

If you need any further information, please feel free to ask further

However

If this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody!
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.