Recent Posts

351

Post New Requests Here / Re: VBA adaptation code for locate strings inside word files

« Last post by Contro on February 03, 2021, 11:04 AM »

Initially i am trying in a security copy in the desktop.

Some files give me errors. Some of them are from external programs for calculations and I don't need to process.
Like EMERGENCIA.doc
I put some screenshots with the errors I am obtaining...

352

Post New Requests Here / Re: VBA adaptation code for locate strings inside word files

« Last post by Contro on February 03, 2021, 10:54 AM »

I am trying the script and seems go well, but with some files I have problem
I can put screenshots if needed

.eml files are processed if contain in the description .doc ?
doing file : ~$5.proyecto.doc and similar are not needed..
pdf files are not needed

where can I control this in the script ?

I only need to process doc, docx and rtf files initially.
And some of them may be excluded like :
EMERGENCIA.doc
beginning with ~$ ,,,,,, doc
and some others
 

353

Post New Requests Here / Re: VBA adaptation code for locate strings inside word files

« Last post by Contro on February 03, 2021, 05:26 AM »

You anticipate that you prefer Powershell.

-Contro (February 02, 2021, 06:04 PM)

I don't anticipate that I prefer PowerShell ...

I only use PowerShell.

-4wd (February 02, 2021, 08:47 PM)

 

354

Post New Requests Here / Re: VBA adaptation code for locate strings inside word files

« Last post by Contro on February 02, 2021, 06:04 PM »

I will try step by step. Seems other type of code. Not VBA. So I have to learn.

You anticipate that you prefer Powershell.

I will study and learn and comment.
Best Regards

355

Post New Requests Here / Re: VBA adaptation code for locate strings inside word files

« Last post by Contro on February 02, 2021, 05:42 PM »

I will try and comment
Best Regards
 

356

Post New Requests Here / Re: VBA adaptation code for locate strings inside word files

« Last post by Contro on January 31, 2021, 12:27 PM »

Can I do a reg script to replace a string in the registry and execute this reg file from a VBA script ?

Best Regards

357

Post New Requests Here / Re: VBA adaptation code for locate strings inside word files

« Last post by Contro on January 30, 2021, 11:19 AM »

How can I adapt this for searching in a folder and its subfolders ?
https://stackoverflo...subfolders-using-vba
 

358

Post New Requests Here / Re: VBA adaptation code for locate strings inside word files

« Last post by Contro on January 30, 2021, 06:43 AM »

In English
Update automatic links on open

https://www.stigview...1-07/finding/V-17811
https://word.tips.ne...Automatic_Links.html

So is possible even throug the windows registry.
The next step may be how to do this with VBA code.

 

359

Post New Requests Here / Re: VBA adaptation code for locate strings inside word files

« Last post by Contro on January 30, 2021, 04:34 AM »

how can I disable with VBA code when opening this window ? :




Notes :
1. Can I disable the window in a certain file ?
2. Can I disable the window when opening any file ?
3. Can I disable the window with VBA code ?

Best Regards

I have located in spanish how to deshabilitate the link update with https://mundo-geek.c...ivos-como-manejarlo/
It would be perfect if I can inhabilitate with VBA code before opening and habilitate when finish...
 

360

Post New Requests Here / Powershell Scripting : VBA adaptation code for locate strings inside word files

« Last post by Contro on January 29, 2021, 11:53 AM »

4wd indicates me this wonderful script to search a string in several word files and adapted for searching in doc files too (not only docx).
This script search word files in a folder.
https://www.datanume...iple-word-documents/
But don't do in its subfolders.
How can this be done ?

Additionally I have a problem of using fields in my word files and when a file is opened a window appear offering to update the links.
the idea is say no to that special windows and make the replace of the string only...

I can offer any information about that warning window if needed .
 

361

General Software Discussion / Re: Multiple Find and replace in a word file

« Last post by Contro on January 29, 2021, 11:23 AM »

Works fine !!!!!!

362

General Software Discussion / Re: Multiple Find and replace in a word file

« Last post by Contro on January 28, 2021, 05:45 AM »

Code: Visual Basic [Select]

1. Sub FindAndReplaceMultiItems()
2.   Dim strFindText As String
3.   Dim strReplaceText As String
4.   Dim nSplitItem As Long
5.    
6.   Application.ScreenUpdating = False
7.  
8.   ' Enter items to be replaces and new ones.
9.  strFindText = InputBox("Enter items to be found here,seperated by | (vertical bar): ", "Items to be found")
10.   strReplaceText = InputBox("Enter new items here, seperated by | (vertical bar): ", "New items")
11.   nSplitItem = UBound(Split(strFindText, "|"))
12.  
13.   ' Find each item and replace it with new one respectively.
14.  For nSplitItem = 0 To nSplitItem
15.     With Selection
16.       .HomeKey Unit:=wdStory
17.       With Selection.Find
18.         .ClearFormatting
19.         .Replacement.ClearFormatting
20.         .Text = Split(strFindText, "|")(nSplitItem)
21.         .Replacement.Text = Split(strReplaceText, "|")(nSplitItem)
22.         .Format = False
23.         .MatchWholeWord = False
24.       End With
25.     Selection.Find.Execute Replace:=wdReplaceAll
26.   End With
27. Next nSplitItem
28.  
29.   Application.ScreenUpdating = True
30.  
31. End Sub

Try that, it uses | instead. (Not tested since I'm on a tablet.)

-4wd (January 27, 2021, 05:33 PM)

4wd i will try and comment

Best Regards
 

363

General Software Discussion / Re: Multiple Find and replace in a word file

« Last post by Contro on January 27, 2021, 10:27 AM »

Can I change the delimiters ?
The script tells to seperate the strings with "," .

Can I use other delimiter ? Sometimess the string itself contain a comma....
 

Note : I think I can try to modify the delimiters by try and result.

364

General Software Discussion / Re: Batch Word Text Replacer

« Last post by Contro 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

365

General Software Discussion / Re: Batch Word Text Replacer

« Last post by Contro 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.



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 .
 

366

General Software Discussion / Re: Batch Word Text Replacer

« Last post by Contro 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]

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

or

Code: Text [Select]

1. 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

367

General Software Discussion / Re: Batch Word Text Replacer

« Last post by Contro 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.
 

368

General Software Discussion / Re: Batch Word Text Replacer

« Last post by Contro 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.
 

369

General Software Discussion / Re: Multiple Find and replace in a word file

« Last post by Contro on January 26, 2021, 10:29 AM »

4wd 

this seems go well for me :

https://www.datanume...items-word-document/

370

General Software Discussion / Multiple Find and replace in a word file

« Last post by Contro on January 26, 2021, 10:07 AM »

Microsoft word have a find and replace option to search for a string and replace with another one.

But I need to search for several strings and replace each of them by a replacement one. So i need a multiple find and replace .

Do you know an utility to do this ?

Best Regards

371

General Software Discussion / Re: Batch Word Text Replacer

« Last post by Contro 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.
 

372

General Software Discussion / Re: Batch Word Text Replacer

« Last post by Contro 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.
 

373

General Software Discussion / Re: Batch Word Text Replacer

« Last post by Contro 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.

374

General Software Discussion / Re: Batch Word Text Replacer

« Last post by Contro 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

375

General Software Discussion / Re: Batch Word Text Replacer

« Last post by Contro on January 24, 2021, 07:26 PM »

I don't remember this one either

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