I have an Excel sheet that has a list of PDF names.  I would like to:

1. Search for these PDFs in PDM
2. Get the PDF(local cache) ✓
3. Open the PDF ✓
4. Print the PDF ✓

I have the code working to do Steps 2-4 but only if I know the exact location of the PDF in PDM.   The problem is, I do not always know the exact location, so I would like to search and get the location.

Does anyone happen to have VBA code on how to search for a filename in PDM?