Paul-
Thank you for your response to this. I am trying to runt he script in the attached document. It successfully opens up Adobe Acrobat 8 Profession, but then stops with the following error:
Run-time error '1001':
UnsupportedValueError: Value is unsupported. ===> Parameter cConvID.
When I click "Debug" to show me what statement it is referring to, it points to this line:
"jsObj.SaveAs ThisWorkbook.Path & "\" & "ProductCatalog.txt", "com.adobe.Acrobat.plain-text""
There are a handful of posts in regards to the VBA code to automatically convert PDF to TXT, but I have not been able to find one that works for me. Here are a few other ones that I referenced:
http://www.reddit.com/r/excel/commen...rt_pdf_to_txt/
http://www.myengineeringworld.net/20...iles-into.html
http://forums.adobe.com/message/5429451
http://social.msdn.microsoft.com/For...t?forum=isvvba
Hopefully it is an easy fix to get the part of the script working and then to put all three steps together. Any light you could shed on this situation would be more than appreciated. Thanks!