I have searched and found information on importing excel data into a single PDF but that is not quite what I need. I need to loop through a directory of PDF's and if the pdf document name matchs the field PDF in my excel file then update the PDF Title field with the Title from the spreadsheet.
So basically loop through c:\pdfs and if PDF Name = Excel spreadsheet PDF column value then update the actual PDF Title with the value from the excel spreadsheet column Title. I guess I would have to scan every row of the spreadsheet to see if that PDF existed or not. Is this possible?
|CL01000399.pdf||COMMON POLICY CONDITIONS|
Edit: Sorry, my original reply was wrong. I misunderstood your request.
Yes, this can be done in Acrobat, but it would require the development of a custom-made script and an Action.
Ok thank you!