Batch Renaming for Multiple files
in [Document Management]
|
Prev: My footnotes are not showing up on my document
Next: How to alphabetize a column of names on Excel, Word
From: noband on 26 Apr 2010 13:04 I have an old database application that stored files as Word documents. Each file has the same layout, with an asset number in the same field. I was able to pull the Word files off to a share and now I want to change the file name to the asset number without having to open each file, looking at the number, and then changing it. Does anyone know of a utility that can do this? Thanks
From: Jay Freedman on 26 Apr 2010 14:12
There is no existing utility that will be able to locate the asset number within your files. It will take a custom-written macro, which will have to be instructed on where to look in the file for that number. The macro will open each file, locate the number, and do a Save As with the proper name. This is not a rename, it's a Save As that leaves the original file unchanged. Later you can delete the original files if everything went as planned. The general idea of a macro for opening each file and processing it is shown at http://www.word.mvps.org/FAQs/MacrosVBA/BatchFR.htm. If you don't know the VBA macro language, ask and someone may write the code for you -- but *you* will have to supply the information about how to locate the asset number in the text of the document. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. noband wrote: > I have an old database application that stored files as Word > documents. Each file has the same layout, with an asset number in > the same field. I was able to pull the Word files off to a share and > now I want to change the file name to the asset number without having > to open each file, looking at the number, and then changing it. Does > anyone know of a utility that can do this? > > Thanks |