I'm not even sure how to word this question, but I've been given a challenge,
and I'm not sure how to go about it.

Firstly--I've created an Excel "application" that lets my underwriters fill
out information about their insured and the coverages we're insuring 1-2
times and it will auto populate throughout the rest of the different
documents (which are in separate tabs in the file) we include in an insurance
policy.

One of the documents is a form schedule--where the underwriters can choose
which forms, documentations and manuals they want to include in their package
to their insureds. This part was easy, they check off the form# they want,
hit a button, and I create a list of the forms they choose. Kind of like a
menu--they choose Form #1A, #4B, and #8C let's say. They hit OK, and I
generate a list
Forms you have selected:
#1A - Declarations Page
#4B - Schedule of Locations
#8C - Endorsement

Here's an additional feature they want. They now want the OK button to not
only generate that list, but also pull up the actual Declaration Page, or
Schedule, or Endorsement, which are .doc Microsoft word documents.

Here's my question. Is there a way for VBA in Excel to open up a Microsoft
Word Document, scan for form fields, fill it in with values from the excel
file, and package it in a PDF?

Any help or ideas would be greatly appreciated. Thanks much!