Excel 2010 VBA code to search for cell values in Word document and print the page to pdf

I have an Excel 2010 file that contains a list of invoice numbers. I am trying to loop through these invoice values one at a time to search for the value in a related Word 2010 document. Once the page is located, I need to print that page to/save that page as a PDF file and then move to the next value (the list will contain one to many invoice numbers.)

I have searched the forums (both Word and Excel VBA) and the internet, but have been unable to locate exactly what I am looking for. Most of the results I found deal with mail merge or replacing the values once they are found in Word. I don't want to replace anything, only locate the page and print the current page (will be a one-page document).

The pdf files can be stored in the same location as the original files. (both the Excel and Word documents have the same name and are in the same file folder; the Excel is .xlsx and the Word is .docx file extension.)

Any assistance would be appreciated. Thanks.

Kevin

I have been able to locate additional information on what I am trying to do with Word. It sounds like I need a process to cycle through the 11 different ActiveDocument.StoryRanges to locate my search string. I have found multiple examples of using the different StoryRanges, but have not been able to find the correct combination of holding the searched value to be able to print that current page to PDF. Any assistance would be appreciated. Thanks in advance.

Kevin.