I do not have clue of VBA- even basics, but I always try tweaking of codes that I get from various forums like this. I often use this site to find codes for my personal use, succeeded until today. May be my keyword for search is not clear, hence, this time not worked, the requirement is below; hope there will be an answer.

From excel, i like to search through pdf files located in SharePoint library for a specific keyword, then I should be able to continue the search with the same text for remaining part of the document. (File path and keyword for search will be as cell inputs – say B2 & C2 Respectively).
Apologies, if the question is not clear or if I not followed the rules of the forum.

Best Regards,
Ravi