Rename files in a folder named using windows explorer

[BNCOXUK]

Hi everyone,

Many of us know we can rename multiple files with windows explorer following the steps here:

https://support.microsoft.com/en-us/...press%20ENTER.

I have a folder that already contains many files named using the above way.

Now I need to delete some files in that folder. Instead of repeating the steps again manually, can I have a VBA macro to help me automatically update the names? For example, if there are 3 files named as: XYZ (1), XYZ (2) and XYZ (3). If XYZ (1) is deleted, I want the remaining two files to be renamed as XYZ (1) and XYZ (2) which reflects a new continuous order.

[BNCOXUK]

Thanks for your great help.

[AliGW]

Administrative Note:

It has been only 10 hours since you last posted. Please do not bump threads until 24 hours have passed, and then only once each day. By bumping the post, you have removed it from the Unanswered Threads filter that many forum members use to find posts that need attention. We are all volunteers here who have lives beyond this forum. While you may be awake and working, this is a world wide forum and others may be playing, sleeping or working and not have the time to look into your issues this minute. Patience is important here. If you have an urgent issue, you may wish to look at paying for help in the Commercial Services sub-forum or hiring a professional consultant in your area. Again, please do not bump threads more often than once in every 24 hours: if you get the help you need today, then great, but you really should not count on it. Thanks for your understanding and patience.

[Marc L]

Instead of repeating the steps again manually

Hi,

as this is the obvious best option, may be faster than some VBA procedure …

Anyway elaborate at least how that should work, fill the holes in order there is nothing to guess
or you are enough confident with your Excel / VBA skills to fit any code a helper may share.