re previous post containing code: https://chandoo.org/forum/threads/vba-to-convert-pdf-to-txt.14245/#post-281389
I've tested the code from the above post and my PDF file opens but when the code gets to the line:
"jsObj.SaveAs NewFileName, "com.adobe.acrobat.plain-text" it freezes and the acrobat file is open in acrobat with a dialog box that says:
"File Open Failed"
My variables are as below
Filename = "C:\Users\Richard\Documents\Excel\PDFs_to_Convert\Universal Stmt Aug.pdf"
NewFileName = "C:\Users\Richard\Documents\Excel\PDFs_Converted_to_Xlsx\Universal Stmt Aug.txt"
In Tools References I do have the Acrobat 10.0 Library selected
I have checked my Acrobat settings for Trusted locations, etc and have included my saveAs location in those settings
Any suggestions as to why I'm getting this error
rreily
I've tested the code from the above post and my PDF file opens but when the code gets to the line:
"jsObj.SaveAs NewFileName, "com.adobe.acrobat.plain-text" it freezes and the acrobat file is open in acrobat with a dialog box that says:
"File Open Failed"
My variables are as below
Filename = "C:\Users\Richard\Documents\Excel\PDFs_to_Convert\Universal Stmt Aug.pdf"
NewFileName = "C:\Users\Richard\Documents\Excel\PDFs_Converted_to_Xlsx\Universal Stmt Aug.txt"
In Tools References I do have the Acrobat 10.0 Library selected
I have checked my Acrobat settings for Trusted locations, etc and have included my saveAs location in those settings
Any suggestions as to why I'm getting this error
rreily