Highlight key words and paragraphs in all word documents in a set folder

  • I don't se Word VBA very often, but try this on some dummy files



  • Hi Roy,


    I currently have a macro in excel that converts PDF’s in a folder to word, I was then hoping to run another macro to follow on in excel from the same command to do as mentioned. Then convert the word docs back to pdf, which I think I can do myself.

    I’m yet to try your code, but thought I give you the heads up. ??

  • Hi Roy,


    I have tried to run your script but nothing happens. Please find code below. I did run the first part direct from MS Word 2016 just to test it and it runs a charm. However I need to run it from Excel, to loop through multiple word documents that are in the same folder.


  • See if this works


  • I don’t get any issues if I run my code from word, but I want to run it from excel to look at all word docs in a folder. When I use your code in excel it brings up the error mentioned above.

  • Hi Roy,


    further to my previous comment. Your code works when used with vba in Word, however when checking the individual word documents nothing is highlighted. You can see the word documents being opened and closed when the macro is running, but ideally I’d like it to run from excel.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!