Hello everyone I was given big amount of pdf files and the objective is to write VBA code which will do the following: 1. It will allow to select directory of PDF files. 2. It will open the first PDF file from a given directory. 3. Copy its content (CRTL A, CRTL C). 4. Paste the information in excel workbook (CRTL C). 5. Close PDF file. 6. Save EXCEL file. 7. Repeat for other PDF files and past the information under previously filled cells. If anyone has any VBA code which does similar loops ...