Adding Item to Reference Library

[CDLM14]

Hi VBA gurus,

I created a program which concatenates PDF documents. This program will be distributed to many people. The program uses the available reference "Adobe Acrobat 10.0 Type Library" to create an object. I just noticed some people dont have this installed in their machine and thats a problem as the tool wont run.

Is there a way to automatically add this on WorkbookOpen? or how can I add this either way?

Thanks so much!

[Aflatoon]

If they don't have the type library it's because they don't have the program installed.

[CDLM14]

Aflaton youre right - we need to push this program out to all the users of the tool

thanks very much for your help!

[EirikDaude]

Would you possibly acchieve the same by using late binding of your objects? http://msofficefun.wordpress.com/2011/02/26/early-binding-vs-late-binding-in-office-vba

[SamT]

Aflaton, you're right - we need to push this program out to all the users of the tool

You might want to check your Adobe license and see how many "Seats" you can use the program on first.

Disclaimer, I am assuming you need Adobe Acrobat (not the free reader) to access the library.

[Kenneth Hobs]

Yes, you can use the GUID to add a reference.

http://www.vbaexpress.com/kb/getarticle.php?kb_id=278
http://www.vbaexpress.com/kb/getarticle.php?kb_id=267

Of course you only need that if you add that reference if you use early binding in the code. Most would develop in early binding and use late binding for production. Of course neither method works if the library files are not installed. http://support.microsoft.com/kb/245115