Home > Forum Home > Automating Data Analysis Tasks > Check PDF files for text from Excel file. > VBA is the automation solution Share

VBA is the automation solution

Excel Help for Vba Is The Automation Solution in Automating Data Analysis Tasks


Forum TopicLogin

Vba Is The Automation Solution

Rate this:
(3/5 from 1 vote)
Happy If you download the application from this post, you'll find an open source VBA routine that loops through all PDF files in a directory and creates test files from them. It also analyzes the text content in each file.

What you can do is modify this or use it as an engine so that it checks for the text in your Excel file and creates a matching log for PDF files where the matched are made. If you are unable to make this development yourself, you can always open it up to the community by creating a small project.

I hope this helps.
 Excel Business Forums Administrator
 Posted by on
 
View Full Post

Find relevant Excel templates and add-ins for VBA is the automation solution in the