What I intending on doing is have custom RFQs (Request for Quotes)
that I've created in word and have certain bookmarks in them that I
can reference to put info from the excel sheet into this word file.

Now if the user directed to there local drive and attempted to open a
custom RFQ they've created it may not have the correct bookmarks. So
what I want is to open the directory of "approved" custom RFQs and let
them pick one. If it doesn't exist well they have to submit a request
to have another made to the steering committee.

Make sense? I'll fiddle with your code on Monday an see how it goes.
Thanks for the replies.