title: Open PDF File and Perform Text Search Using excel vba
body: <p>I need to develop a simple excel vba application to do some data validation.  I have excel files with employee information and I need to validate that information against the source document ( a pdf file(s)).  The information in excel is grouped by employee name.  </p>
  
  <p>Is it possible to write a VBA script that will open a specified pdf file, then allow the user to perform a search of the employee name so the pdf jumps to the appropriate employee page?   (Each employee has an individual page in the pdf document.) Once on the employee page the user would review the data, make any necessary edits to the excel file and then search for the next employee. </p>
  
  <p>I believe I can use:</p>
  
  <pre><code>Sub NavigatePDF()
  
  ThisWorkbook.FollowHyperlink "c:\user\target.pdf"
  
  End Sub
  </code></pre>
  
  <p>to open a pdf file, but I don't know how to issue a search from excel vba once I have the file open.  </p>
  
  <p>Can anyone offer any suggestions or point me to some useful resoucres. </p>