The code works after adding the reference (in my case the acrobat.tdl), however after saving and closing the reference disappears. With the correct references the process works start to finish. When I reopen Excel and the reference has been replace to Acrobat 10.0 Type Library (and the .tdl is no longer checked) this happens:

At this line: Set PartDocs(i) = CreateObject("AcroExch.PDDoc"), a dialog box opens that says:

clip.jpg


When I cancel and continue, the process works, but the idea is to have this run automatically. Neither suppressing ScreenUpdating nor EnableEvents works.

I need to figure out how to persist the correct reference even after saving/closing or suppress this messaging.

Thanks.