PDA

View Full Version : MULTIPLE PDF TO SINGLE EXCEL WITH OVERWRITE



HelloWorld!
04-21-2015, 07:04 AM
Hi,

I have folder(Name:A) with 100s of pdf files. I want a vbscript that would convert all the pdf file in folder(A) to a single excel worksheet.When run again, it should also be able to overwrite on the existing excel file without any error.
I am using excel 2013 and adobe reader for this. I ll be using power query to further filter this data so no special columns or rows needs to matched between pdf and excel file in this script.
I have checked a lot but have not been able to find something that would do this.

Your help is greatly appreciated
Thank You! :)

tremblingtig
04-22-2015, 11:29 AM
If this is something you tend to do often, it might be worth looking into a batch file PDF to Excel converter like PDF2XL CLI. There's a free trial version on the website, so maybe give it a try and see if it works for you. Just go to the CogniView website and look for PDF2XL CLI in the products list.