Thread: PDF to Excel
View Single Post
 
Old 02-15-2014, 11:47 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-

Thank you for getting back to me so quickly. I have actually run into two small problems.

When trying to run the code you specified above, I get a Compile Error: Syntax Error on this line- "
strPDF = "ThisWorkbook.Path & "\" & "ProductCatalog.pdf"".

The part of the scrip that deletes the two old files might actually not be needed because the couple time I tested the script, it automatically deleted the files already.

The second issue I have come across is when running the Convert_PDF_To_Text_File script in a production
environment. It runs as planned in my test environment, but when I try to run it on the full version of
my Inventory/Cost sheet it gives me the follow error: Compile error: User-defined type not defined and it points to this line "Dim AcroXApp As Acrobat.Acroapp"

I tried to recreate this scrip a number of times and made sure that it exactly matched the one I am running in my test environment which it does. Any thoughts on why this would run in one location and not the other?
Reply With Quote