Quote:
Originally Posted by shanemarkley
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.
|
Did you define strPDF the way I said to (i.e. with the Dim statement outside the code module)?
Quote:
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"
|
Is Acrobat Pro installed in the production environment? And, if you installed the code there, rather than installing the workbook containing it, did you set a reference to Acrobat, via Tools|References in the VBE?
02-15-2014, 09:07 PM
Similar Threads
[Excel 2007] Building Power Point Slides from data in an Excel Table
Windows 7 32bit 
Office 2010 32bit
Threaded Mode