Change files names in a folder

try this
- I have added a few variables to make things easier to follow

Look in Immediate window to see if you are getting expected results (old name and new name listed together)
(see immediate window when in VBA editor with {CTRL} G )

After testing remove the apostrophe to rename the files

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Try adding this line at the beginning

Please Login or Register  to view this content.

You may have some file names without extensions or something

If that works then I will post more robust update code tomorrow
(I tested against a folder without subfolders and with perfect files)

Do not remove the red apostrophe!

Function added to create the new file name
Before doing so the old file name is checked and bad names are rejected
Results are written to a new worksheet
Any rows which are blank in column B are problem names and are excluded from the conversion
Activate the red line AFTER fully testing!

Please Login or Register  to view this content.

Activate the red line AFTER fully testing!

Did you remove the apostrophe at beginning of this line?

Please Login or Register  to view this content.

That is peculiar
- this would happen if the folder does not exist (ie if you are moving files to a new folder)
- but you are renaming files in the same folder (so the folder path must exist)

Perhaps the path contains a tiny error.
Test like this:

FIRST use File Manager to navigate to the folder
\ right click on one of the files
\ click on Properties
\ Security
\ look for Object Name and highlight & copy the full path including file name and extension

NEXT go back to Excel and paste it below the original entry for that file

Are they IDENTICAL ?

NEXT look at column B
- does the new path & file name & extension look correct?

Suggest you post your question here https://www.excelforum.com/for-other...mobile-os-etc/
and name the platform that you are using
Good luck

Hi sajnica89bg,

Unfortunately your post does not comply with Rule 4 of our Forum RULES.

Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.