If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Batch Renaming for Multiple files
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 |
#2
|
|||
|
|||
Batch Renaming for Multiple files
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 |
Thread Tools | |
Display Modes | |
|
|