Author Topic: Batch Word Text Replacer (Read 8166 times)

Contro · « **on:** January 24, 2021, 04:58 PM »

With Acrobat I can replace in a pdf collection a text string.

I need a free to replace in a word collection files replace any string .
I can with notepad++ or with DocFetcher find any string in any collection of microsoft word files.
I am using microsoft word 2010.
If I try to use notepad++ for finding and replacing the word files i corrupt them. So I can only use notepad++ to find, but not to replace.

I need someone with experience doing this work to recommend me the most simple, preferably free, program.

Best Regards

Contro · « **Reply #1 on:** January 24, 2021, 05:24 PM »

I tried with Gillmeister word text replacer but don't go. The program hangs and do nothing.

4wd · « **Reply #2 on:** January 24, 2021, 06:21 PM »

You can give this a try:
https://www.datanume...iple-word-documents/

Contro · « **Reply #3 on:** January 24, 2021, 07:17 PM »

You can give this a try:
https://www.datanume...iple-word-documents/
-4wd (January 24, 2021, 06:21 PM)

I am trying long time ago with this sort of program.
So : Have you try that script or the program ? Do you use this program ?

I hardly can remember the VBA Find and Replace as useful.
https://gregmaxey.co...ind_and_replace.html

This sort of utilities are very painful sometimes. corrupt files. you need to backup everywhere.

Contro · « **Reply #4 on:** January 24, 2021, 07:26 PM »

I don't remember this one either

http://www.gmayor.co..._batch_processes.htm

$:-\$

4wd · « **Reply #5 on:** January 25, 2021, 02:25 AM »

You can give this a try:
https://www.datanume...iple-word-documents/
-4wd (January 24, 2021, 06:21 PM)
I am trying long time ago with this sort of program.
So : Have you try that script or the program ? Do you use this program ?
-Contro (January 24, 2021, 07:17 PM)

I don't have/use Word or VBA, if I did I'd probably use PowerShell interfacing to Word to do the same thing instead.

Contro · « **Reply #6 on:** January 25, 2021, 09:45 AM »

You can give this a try:
https://www.datanume...iple-word-documents/
-4wd (January 24, 2021, 06:21 PM)
I am trying long time ago with this sort of program.
So : Have you try that script or the program ? Do you use this program ?
-Contro (January 24, 2021, 07:17 PM)

I don't have/use Word or VBA, if I did I'd probably use PowerShell interfacing to Word to do the same thing instead.
-4wd (January 25, 2021, 02:25 AM)

Ojú !!!!!!!!!! Then you don't have used datanumen .
I would prefer an advice if you are using this tool or know at first hand someone doing.
Best Regards

Contro · « **Reply #7 on:** January 25, 2021, 09:47 AM »

I don't remember my prior use of the VBA scripts. Seems for old versions of word o something goes wrong when replacing.

So I would like a tool tested and running with word 2010.

Note : the important thing after replacing is not obtain corrupted word files I can't open.

4wd · « **Reply #8 on:** January 25, 2021, 07:28 PM »

Ojú !!!!!!!!!! Then you don't have used datanumen .
I would prefer an advice if you are using this tool or know at first hand someone doing.
-Contro (January 24, 2021, 07:17 PM)

No problem ... however that VBA module is from 2017 and I've just tested it on Word 2003 and it worked ...

Shades · « **Reply #9 on:** January 25, 2021, 08:43 PM »

So I would like a tool tested and running with word 2010.
-Contro (January 25, 2021, 09:47 AM)

Just a note: Office 2010 is not supported anymore by Microsoft, in the same way that Windows 7 isn't supported anymore. It is Office 2013 or bust (in the eyes of Microsoft). For the next 2 years still, after that no more support for Office 2013 either.

Contro · « **Reply #10 on:** January 26, 2021, 09:33 AM »

Ojú !!!!!!!!!! Then you don't have used datanumen .
I would prefer an advice if you are using this tool or know at first hand someone doing.
-Contro (January 24, 2021, 07:17 PM)

No problem ... however that VBA module is from 2017 and I've just tested it on Word 2003 and it worked ...
-4wd (January 25, 2021, 07:28 PM)

Then running to try.

Contro · « **Reply #11 on:** January 26, 2021, 10:03 AM »

I am doing something wrong.
No replaces at all.
As works inside a folder a create a folder with the word files. Try a string a see no change.

rjbull · « **Reply #12 on:** January 26, 2021, 02:41 PM »

Try HandyFile Find and Replace Text Aid Kit Office Edition. It definitely isn't free. Web site blocked by Malwarebytes, but they tend to false positives. I used an old edition of HFFR years ago for other purposes.

Contro · « **Reply #13 on:** January 26, 2021, 03:01 PM »

Try HandyFile Find and Replace Text Aid Kit Office Edition. It definitely isn't free. Web site blocked by Malwarebytes, but they tend to false positives. I used an old edition of HFFR years ago for other purposes.
-rjbull (January 26, 2021, 02:41 PM)

I have visited this webpage. https://silveragesoftware.com/index.php

and some links goes to https://play.google....=6944889935549986731

There are error in the webpage and don't go.

Contro · « **Reply #14 on:** January 26, 2021, 03:03 PM »

Another strange web page is https://www.binaryma...download?ref=gallery
When you try the program observe strange things.
$:-\$

4wd · « **Reply #15 on:** January 26, 2021, 06:49 PM »

I am doing something wrong.
No replaces at all.
-Contro (January 26, 2021, 10:03 AM)

That's because it looks for *.docx files by default, you need to change it to *.doc.
Changing it to *.doc? would probably do both types but I haven't tested it.

Code: Text [Select]

strFile = Dir(strFolder & "\" & "*.doc", vbNormal)

or

Code: Text [Select]

strFile = Dir(strFolder & "\" & "*.doc?", vbNormal)

Contro · « **Reply #16 on:** January 27, 2021, 04:09 AM »

I am doing something wrong.
No replaces at all.
-Contro (January 26, 2021, 10:03 AM)

That's because it looks for *.docx files by default, you need to change it to *.doc.
Changing it to *.doc? would probably do both types but I haven't tested it.

Code: Text [Select]
strFile = Dir(strFolder & "\" & "*.doc", vbNormal)
or
Code: Text [Select]
strFile = Dir(strFolder & "\" & "*.doc?", vbNormal)
-4wd (January 26, 2021, 06:49 PM)

I'll try and comment.

By the way I have tried the old VBA Find And Replace https://gregmaxey.co...ind_and_replace.html
But only goes well for me the option with a single phrase and replace in an opened document

Contro · « **Reply #17 on:** January 27, 2021, 06:43 AM »

RESULTS

The script only works in the folder selected. Not in its subfolders. . I suppose this is perfectly correct. The script opens file by file doing the replaces and many of my files hace codes and fields to be updated. But goes well anyway. Obviously this limits because I think is not good maintain opened a huge amount of files in replace action waiting for my decision.... Below a window that appear in almost any of my word files.

AsusPortatil - 27_01_2021 , 12_37_24.png

Batch Word Text Replacer

I usually doc format in general. Recently I observ that I even can save as a docx file and allow me to make the fusion/combination of fields from Goldmine 5.5 (a CRM I use many years ago, a legacy version) . In the experiment after modify the script only find and replace in the doc files, not in the docx files.
So a possible modification of the script is the ability to process doc and docx files.

Note : sorry I need a new glasses. I will try doc? and comment .

Contro · « **Reply #18 on:** January 27, 2021, 10:25 AM »

Goes well

!!!!!!!!!

All may be better, but for now is enough for me. Perhaps an implementation to examine an entire folder and its subfolders but taking care not to open a huge amount of files to not collapse the system.

P.D. In the post multi find and replace in a document I have something to please for ....
https://www.donation...?topic=51006.new#new

ConstanceJill · « **Reply #19 on:** January 28, 2021, 02:46 AM »

Just a note: Office 2010 is not supported anymore by Microsoft, in the same way that Windows 7 isn't supported anymore.[…]
-Shades (January 25, 2021, 08:43 PM)

Yeah, it's supposed to be end of life since october of 2020, but they still published patches for it this month (for example KB4493145). Maybe someone over there forgot about it?

wraith808 · « **Reply #20 on:** January 28, 2021, 07:04 AM »

Just a note: Office 2010 is not supported anymore by Microsoft, in the same way that Windows 7 isn't supported anymore.[…]
-Shades (January 25, 2021, 08:43 PM)
Yeah, it's supposed to be end of life since october of 2020, but they still published patches for it this month (for example KB4493145). Maybe someone over there forgot about it?
-ConstanceJill (January 28, 2021, 02:46 AM)

If it's a critical patch, they still publish them a while after, I've found.

KodeZwerg · « **Reply #21 on:** February 18, 2021, 06:24 AM »

When I do have some more free time left, I might be able to program an OLE/COM based word text-search&replace mechanism.
(It would need to have original Microsoft Word [or Office with Word] installed to do it's job)

Contro · « **Reply #22 on:** February 23, 2021, 04:16 AM »

When I do have some more free time left, I might be able to program an OLE/COM based word text-search&replace mechanism.
(It would need to have original Microsoft Word [or Office with Word] installed to do it's job)
-KodeZwerg (February 18, 2021, 06:24 AM)

Perfect. It's a good alternative.
Best Regards