I need to rename all my Excel, Word and pdf files with client name in front. Many of them don't bear the client name in the title at present. Is there a program that would do this for all existing files? How would I get an automatic client name when saving new files?
Replies (6)
Please login or register to join the discussion.
If you have the files in client folders then Bulk Rename - here https://www.bulkrenameutility.co.uk/Main_Intro.php - works pretty well using wild cards.
As for getting the client name automatically for new files surely you just need to be strict with yourself in following your file naming protocol?
How good are you with VBA? http://www.dragondrop.com/default.asp find and replace macro for word has some useful code snippets which would help you build something yourself
Should be able to do the first with a DOS command I would have thought: https://www.computerhope.com/renamehl.htm
dunno about the second. MS Flow?
For a quick rename I would recommend the "advanced rename" function within FileLocator Lite (free for commercial use). It's also a very handy search program.
Sounds like a custom build application to me.
I did a similar one the other day for a chap who asked me to list all his Excel Workbooks and Word Documents from an Add-In using VBA.
Here is a link to it:
www.fd4cast.com/ListExcelWordFiles.zip
When you load it the Add-In should appear between the 'File' tab and the 'Home' tab on the main ribbon. Let me know if you don't see it.
Happy to customise it to do what you would like it to do if you want to discuss further.
See more case studies at:
I use Nexusfile
Also handy for copying files when some are in the destination already as it will intelligently check rather than the windows standard ???
As for naming new files - you just need to be disciplined with your naming convention