I would love a VB code or something or some sort to help me with this problem, its a very important task for me. How can I find a certain text string in a PDF file (located in a certain drive) and either pull the text from the .pdf and put it in a cell, or automatically print 3 levels of text strings withing the first .PDF Here are some details as to what I actually want. There is this PDF file named "Parent12345.pdf" I want to enter that Number (Parent12345.pdf) into an excel sheet and the code will look for "child34.Pdf" within the Parent12345.pdf and print that "child34.Pdf." if found. and also it would be great to go into a further level of finding the next text string of "child34.pdf" and find "baby30.pdf" and print it automatically. So bottom line, I want to enter "Parent12345" in a cell, and it will print that file via left click or defined macro. then it will find "child34" WITHIN "Parent12345" and print it, AND find "baby30" within "child34" and print the Pdf files. I don't know if this is possible with Excel and VB, But I'm sure someone can point me in the right direction. even if I have to use a third party program.