View original (French)

Unregistered library

atoll24 -  
yg_be Posted messages 23437 Registration date   Status Contributor Last intervention   -

Hello,

I am using Access 2013 and I want to update an Excel sheet with VBA, but I get this error:

Runtime error '-2147319779 (8002801d)'
Automation error
Library not registered

I checked the references, apparently nothing is missing, here’s everything that’s checked:

     Visual Basic for Applications

     Microsoft Access 15.0 Object library

     OLE Automation

     Microsoft Visual Basic for Applications Extensibility 5

     Microsoft Excel 15.0 Object library

     Microsoft ActiveX Data Objects 2.0 Library

     Microsoft ADO Ext 6.0 for DDL and Security

     Microsoft Smart Tags 2.0 Type Library

     Microsoft Office 15 Access Database Engine Object Library

Does anyone have any idea on how to correct this error?

Thank you in advance.


1 answer

  1.
    yg_be Posted messages 23437 Registration date   Status Contributor Last intervention   Ambassadeur 1 588
     

    Hello,

    Can you share your code and indicate on which line the error occurs?

    0