Hi,

I am fairly new at VBA so bare with my complete ignorance.

I have an Excel sheet containing a simple list of "chains" contain in sheet2 column A

I want to integrate a small form to open the msOpenDialog to open multiple word files and clicking OK launch the treatment.

The process:
For each file selected:
- Check the content for the "strings" contained in the Excel sheet
- if a string is found "highlight" it in the Word document
- Once all strings are checked in the document save amended Word Document as ORIGINAL_NAME_prepped.

The macro must work with Office 2003, 2007 and 2010

Thank you for your help.

Hacène

Hi

Instead of msOpenDialog can you try common dialog. You can store the path / files and then loop through the same.

http://vbadud.blogspot.com/2007/06/v...on-dialog.html

You can use Find method to search for text (http://vbadud.blogspot.com/2012/01/h...ag-string.html)

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)