![]() |
|
#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 Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
[Excel 2007] Building Power Point Slides from data in an Excel Table
|
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 |
Excel 2011 can't open old Excel 98 or Excel X files
|
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 |
saving data in excel 2010 from excel 2003
|
johnkcalg | Excel | 1 | 02-06-2012 07:33 PM |