The error occurs in the Sub SavePDFAs where the code initializes Acrobat by creating the APP Object. By adding in random MsgBox "tests", I can tell that the code passes through this part perfectly fine. The outer piece is completely fine - it checks whether you have the file path in there and whether everything is in the correct format, and then it calls the sub "SavePDFAs".
I'm using Excel 2010, so I don't necessarily think there are any compatibility issues. I have Adobe Acrobat Pro DC installed, and all previous version of Adobe Reader uninstalled. So I decided to look into the code to check where exactly it's hiccuping.įirst of all, I've followed the directions, went into tools -> references and checked Adobe Acrobat 10.0 Type Library. However, every time I try to run the code (I downloaded the 2nd version btw where it's a zip folder) by clicking Convert Files, my Excel crashes instantly with the pop-up box of "Microsoft Excel has stopped working." I'm not super familiar with VBA and even less with Adobe API, but I got this code from this website which seems to be exactly what I need. I have a few thousand similar PDF files that I would like to convert to Excel workbooks.
0 kommentar(er)
