I have went through all of the post on this in this Forum and many others and have had no luck. Here is the only thing that I could find that comes close to working for me. But I would have to create code to have this work. http://www.glynnconsulting.co.uk/RenameFiles.zip The problem I'm having is when there are semi-duplicates. For example if I have
id_4701_01.txt
id_4701_02.txt ***This is the format that all of my .txt files are in. And there may be more than one that has this happen.
*the end result for all files needs to be id_4701.txt and in the case were there may be two I want to just rename the first one that the VBA code finds
All I'm trying to do is have VBA Code rename all files in a folder to get rid of the _01 (or other _0X "x" being another number) Any help would be greatly appreciated.
**Note: The big picture is that I am automating alot of tasks that we currently do and have them run automatically over night and be done when we get in.
Bookmarks