https://vbatutorialcode.com/open-many...
In this video, I open all the PDF files in a particular folder in Internet Explorer regardless of how many PDFs are in the folder. You can combine this video with my Adobe PDF text grabber video to pull data from unlimited PDFs into Excel with VBA.