Importing libraries explicitly in macro code

[shivboy]

I am working on a project which uses the following object libraries:

Microsoft DAO 3.6 Object Library
Microsoft ADO Ext. 2.8 for DDL and Security
Microsoft Access 10.0 Object Library
Microsoft ActiveX Data Objects 2.0 Library

How can I explicitly inherit these libraries in my macro code so that no error is thrown due to non-inheritance of the libraries in user's machine.

Furthermore, is there a location where I can find the complete reference list of these libraries?

Please help.

Peace,

Shivboy

[Ivan F Moala]

on my system I got this



C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL .AddFromGuid "{000204EF-0000-0000-C000-000000000046}",4,0
C:\Program Files\Microsoft Office\Office\EXCEL9.OLB .AddFromGuid "{00020813-0000-0000-C000-000000000046}",1,3
C:\WINDOWS\system32\stdole2.tlb .AddFromGuid "{00020430-0000-0000-C000-000000000046}",2,0
C:\Program Files\Microsoft Office\Office\MSO9.DLL .AddFromGuid "{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}",2,1
C:\Program Files\Microsoft Office2003\OFFICE11\msoutl.olb .AddFromGuid "{00062FFF-0000-0000-C000-000000000046}",9,2
C:\Program Files\Microsoft Office2003\OFFICE11\MSACC.OLB .AddFromGuid "{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}",9,0
C:\Program Files\Common Files\System\ado\msado20.tlb .AddFromGuid "{00000200-0000-0010-8000-00AA006D2EA4}",2,0
C:\Program Files\Common Files\System\ado\msadox.dll .AddFromGuid "{00000600-0000-0010-8000-00AA006D2EA4}",2,8
C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll .AddFromGuid "{00025E01-0000-0000-C000-000000000046}",5,0




Lookup AddFromGuid

and perhaps look @ this thread
http://www.mrexcel.com/board2/viewtopic.php?t=8251&highlight=guid