Thread: PDF to Excel
View Single Post
 
Old 01-30-2014, 05:54 AM
shanemarkley shanemarkley is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Dec 2013
Posts: 29
shanemarkley is on a distinguished road
Default

Paul-

I figured out what was wrong with the conversion script. It was trying to save it as plain text instead of accessible text. I fixed it by changing the code to read:

jsObj.SaveAs ThisWorkbook.Path & "\" & "ProductCatalog.txt", "com.adobe.acrobat.accesstext"

All three scripts now successfully run if you run them individually in order. The last step is to put all three of these scripts together into a single macro. There is a brief delay when downloading the file and also when converting the script since its a 800 page PDF file so I am not sure how this needs to be reflected when combining all three. Is this something you can help with?
Reply With Quote