Need template to automatically add ".doc" extension and rename fil Ned23 12/11/2008 6:44:00 PM Hi, I've got about 40,000 word perfect files I need to convert to Word 2007. I've found a couple of batch converters but the problem is that they work only on files with a single ".doc" extension. Most WP fiiles I have end in ..wp or .wpd or from really old versions of WP the file extension is just the initals of the person who created them (for example, Michael B. Smith may have created a WP file in 1996 named: "FILE203.MBS") So, what I need now is a template add-in or macro to automatically add a ".doc" extension to a folder full of files as a batch operation. Preferably one that preserves the original extension, so that Michaels file above would be renamed: "FILE203.MBS.DOC"

Re: Need template to automatically add ".doc" extension and rename fil "Graham Mayor" <gmayor[ at ]REMOVETHISmvps.org> 12/12/2008 6:58:42 AM You don't need a macro for this, it is very simple to do with a DOS command. Copy the appropriatye following text into notepad and save it as DOSHERE.REG From Windows Explorer, right click and merge the resulting file with the registry. This will add a "Run MS-DOS Prompt here" if you right click any folder in Windows Explorer for Windows XP: REGEDIT4 [HKEY_CLASSES_ROOT\Directory\Shell\DosPrompt] [ at ]="Run MS-DOS Prompt here" [HKEY_CLASSES_ROOT\Directory\Shell\DosPrompt\Command] [ at ]="Cmd /k CD \"%1\" " for Vista REGEDIT4 [HKEY_CLASSES_ROOT\Directory\shell\DosHere] [ at ]="Command &Prompt Here" [HKEY_CLASSES_ROOT\Directory\shell\DosHere\Command] [ at ]="C:\\WINDOWS\\system32\\cmd.exe /k cd \"%1\"" Select the folder containing the files right click and run the dos prompt. A DOS window will open with the path at the cursor type REN *.* *.*.doc thats RENspace*.*space*.*.doc and press enter Job done! Repeat for any other folders with files. Or you could use a Windows rename application - I rather like Better File Rename - http://www.publicspace.net/windows/BetterFileRename/index.html -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Ned23 wrote: [Quoted Text] > Hi, > > I've got about 40,000 word perfect files I need to convert to Word > 2007. I've found a couple of batch converters but the problem is that > they work only on files with a single ".doc" extension. Most WP > fiiles I have end in .wp or .wpd or from really old versions of WP > the file extension is just the initals of the person who created > them (for example, Michael B. Smith may have created a WP file in > 1996 named: "FILE203.MBS") > > So, what I need now is a template add-in or macro to automatically > add a ".doc" extension to a folder full of files as a batch > operation. Preferably one that preserves the original extension, so > that Michaels file above would be renamed: "FILE203.MBS.DOC"

Re: Need template to automatically add ".doc" extension and rename Ned23 12/17/2008 10:14:01 PM Thanks, that's helpful. I can do that, but I'm not sure the many computer-challenged employees here in the office can do that. Most of them don't even have admin privileges and cannot edit the registry. I was hoping for something easier. I may have to assign someone to do this whole task at a special worstation for a week. "Graham Mayor" wrote: [Quoted Text] > You don't need a macro for this, it is very simple to do with a DOS command. > > Copy the appropriatye following text into notepad and save it as DOSHERE.REG > From Windows Explorer, right click and merge the resulting file with the > registry. This will add a "Run MS-DOS Prompt here" if you right click any > folder in Windows Explorer > > for Windows XP: > > REGEDIT4 > > [HKEY_CLASSES_ROOT\Directory\Shell\DosPrompt] > [ at ]="Run MS-DOS Prompt here" > [HKEY_CLASSES_ROOT\Directory\Shell\DosPrompt\Command] > [ at ]="Cmd /k CD \"%1\" " > > > for Vista > > REGEDIT4 > > [HKEY_CLASSES_ROOT\Directory\shell\DosHere] > [ at ]="Command &Prompt Here" > [HKEY_CLASSES_ROOT\Directory\shell\DosHere\Command] > [ at ]="C:\\WINDOWS\\system32\\cmd.exe /k cd \"%1\"" > > > Select the folder containing the files right click and run the dos prompt. > A DOS window will open with the path at the cursor > > type > > REN *.* *.*.doc > > thats RENspace*.*space*.*.doc > > and press enter > > Job done! > > Repeat for any other folders with files. > > Or you could use a Windows rename application - I rather like Better File > Rename - http://www.publicspace.net/windows/BetterFileRename/index.html > > > -- > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Graham Mayor - Word MVP > > My web site www.gmayor.com > Word MVP web site http://word.mvps.org > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > > > Ned23 wrote: > > Hi, > > > > I've got about 40,000 word perfect files I need to convert to Word > > 2007. I've found a couple of batch converters but the problem is that > > they work only on files with a single ".doc" extension. Most WP > > fiiles I have end in .wp or .wpd or from really old versions of WP > > the file extension is just the initals of the person who created > > them (for example, Michael B. Smith may have created a WP file in > > 1996 named: "FILE203.MBS") > > > > So, what I need now is a template add-in or macro to automatically > > add a ".doc" extension to a folder full of files as a batch > > operation. Preferably one that preserves the original extension, so > > that Michaels file above would be renamed: "FILE203.MBS.DOC" > > >

Re: Need template to automatically add ".doc" extension and rename "Graham Mayor" <gmayor[ at ]REMOVETHISmvps.org> 12/18/2008 10:14:38 AM You said that *you* had 40000 docs to rename. This was a quick way for *you* to do it. In order to use a macro to perform the function you would have to open the document in Word to do so and there lies the essential dilemma. I often see requests from organisations who want to convert a shed load of documents from (say) WordPerfect to Word and wonder why? The conversion is rarely going to be perfect, so to convert them all, even if you overcome the name issue is going to be a mammoth task. Surely it would make far more sense to convert them on an ad hoc basis as they are required for use? How many of the 40,000 will ever be required again? I suspect very few. I would leave them as WP format until they are required and create new Word templates from those that are being used as pro-forma letters rather than the widespread dubious practice of renaming altered documents. -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Ned23 wrote: [Quoted Text] > Thanks, that's helpful. I can do that, but I'm not sure the many > computer-challenged employees here in the office can do that. Most > of them don't even have admin privileges and cannot edit the registry. > > I was hoping for something easier. I may have to assign someone to > do this whole task at a special worstation for a week. > > "Graham Mayor" wrote: > >> You don't need a macro for this, it is very simple to do with a DOS >> command. >> >> Copy the appropriatye following text into notepad and save it as >> DOSHERE.REG From Windows Explorer, right click and merge the >> resulting file with the registry. This will add a "Run MS-DOS Prompt >> here" if you right click any folder in Windows Explorer >> >> for Windows XP: >> >> REGEDIT4 >> >> [HKEY_CLASSES_ROOT\Directory\Shell\DosPrompt] >> [ at ]="Run MS-DOS Prompt here" >> [HKEY_CLASSES_ROOT\Directory\Shell\DosPrompt\Command] >> [ at ]="Cmd /k CD \"%1\" " >> >> >> for Vista >> >> REGEDIT4 >> >> [HKEY_CLASSES_ROOT\Directory\shell\DosHere] >> [ at ]="Command &Prompt Here" >> [HKEY_CLASSES_ROOT\Directory\shell\DosHere\Command] >> [ at ]="C:\\WINDOWS\\system32\\cmd.exe /k cd \"%1\"" >> >> >> Select the folder containing the files right click and run the dos >> prompt. A DOS window will open with the path at the cursor >> >> type >> >> REN *.* *.*.doc >> >> thats RENspace*.*space*.*.doc >> >> and press enter >> >> Job done! >> >> Repeat for any other folders with files. >> >> Or you could use a Windows rename application - I rather like Better >> File Rename - >> http://www.publicspace.net/windows/BetterFileRename/index.html >> >> >> -- >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<> >> Graham Mayor - Word MVP >> >> My web site www.gmayor.com >> Word MVP web site http://word.mvps.org >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<> >> >> >> Ned23 wrote: >>> Hi, >>> >>> I've got about 40,000 word perfect files I need to convert to Word >>> 2007. I've found a couple of batch converters but the problem is >>> that they work only on files with a single ".doc" extension. Most >>> WP fiiles I have end in .wp or .wpd or from really old versions of >>> WP the file extension is just the initals of the person who created >>> them (for example, Michael B. Smith may have created a WP file in >>> 1996 named: "FILE203.MBS") >>> >>> So, what I need now is a template add-in or macro to automatically >>> add a ".doc" extension to a folder full of files as a batch >>> operation. Preferably one that preserves the original extension, >>> so that Michaels file above would be renamed: "FILE203.MBS.DOC"