![]() |
#32
|
|||
|
|||
![]()
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? |
Tags |
adobe, conversion, pdf |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
bremen22 | Excel Programming | 1 | 08-07-2013 11:01 AM |
Paste special an Excel range into Outlook as an Excel Worksheet | charlesh3 | Excel Programming | 3 | 02-04-2013 04:33 PM |
![]() |
FLJohnson | Excel | 8 | 05-09-2012 11:26 PM |
Excel 2007 custom ribbon not showing in Excel 2010 | Paulzak | Excel | 2 | 02-17-2012 06:35 PM |
![]() |
johnkcalg | Excel | 1 | 02-06-2012 07:33 PM |