Need template to automatically add ".doc" extension and rename fil

N

Ned23

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"
 
G

Graham Mayor

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]
@="Run MS-DOS Prompt here"
[HKEY_CLASSES_ROOT\Directory\Shell\DosPrompt\Command]
@="Cmd /k CD \"%1\" "


for Vista

REGEDIT4

[HKEY_CLASSES_ROOT\Directory\shell\DosHere]
@="Command &Prompt Here"
[HKEY_CLASSES_ROOT\Directory\shell\DosHere\Command]
@="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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
N

Ned23

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 said:
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]
@="Run MS-DOS Prompt here"
[HKEY_CLASSES_ROOT\Directory\Shell\DosPrompt\Command]
@="Cmd /k CD \"%1\" "


for Vista

REGEDIT4

[HKEY_CLASSES_ROOT\Directory\shell\DosHere]
@="Command &Prompt Here"
[HKEY_CLASSES_ROOT\Directory\shell\DosHere\Command]
@="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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

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"
 
G

Graham Mayor

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


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 said:
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]
@="Run MS-DOS Prompt here"
[HKEY_CLASSES_ROOT\Directory\Shell\DosPrompt\Command]
@="Cmd /k CD \"%1\" "


for Vista

REGEDIT4

[HKEY_CLASSES_ROOT\Directory\shell\DosHere]
@="Command &Prompt Here"
[HKEY_CLASSES_ROOT\Directory\shell\DosHere\Command]
@="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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top