Recent Posts

351

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

« Last post by Contro on February 04, 2021, 12:19 PM »

I put this :
     
      $list = Get-ChildItem "$($srce)\*" -Include *.doc* -exclude ~*,*.mem.doc,~*,*.rey.doc,~*,*.CTF.doc,~*,*.anx.doc,~*,*.pry.doc,~*,*.PST.doc, -Recurse # Add more to exclude if necessary

I'll put in a few days the window I wish to deactivate and how I do throught the options in microsoft word.
 

352

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

« Last post by Contro on February 03, 2021, 01:30 PM »

So :
1. I need a filter to filter what types and names I want to process

2. I would like too an option to manipulate the windows registry , specially if a window appear when opening the word file.

 

353

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

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

I need to exclude these too :
*.MEM.doc
*.PST.doc
*.pry.doc
*.anx.doc
*.CTF.doc
*.rey.doc

I am trying to determine if the supposed eml and pdf intercepted are because or not containing the string .doc in the description ....

354

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

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

I''ll make an experiment to see if process eml files or pdf files creating a folder with this type of files.
When need to depure something I observ microsoft word interaction goes to open the program directly and then I have the window of the program open.

 

355

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

356

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
 

357

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)

 

358

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

359

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
 

360

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

361

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
 

362

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.

 

363

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

364

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 .
 

365

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 !!!!!!

366

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
 

367

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.

368

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

369

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 .
 

370

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

371

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.
 

372

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.
 

373

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/

374

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

375

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.