Hi,

I have been using an excel macro which opens and automates AutoCAD drawings for about a year now, we recently bought 3 new computers with AutoCAD Mechanical 2016 and office 2016 installed.
Every time I run the macro it would hit an immediate error : 2147319779 : automation error library not registered, this happens with all 3 computers.

The macro is designed to detect the correct autoCAD version and add the correct references.
I have checked in VB > tools > references all required references have been ticked, but the error would still appear upon running the macro.

I have tried:
- uninstall and reinstall excel and autoCAD
- formatting the computer and reinstalling everything
- replacing the AutoCAD references with files form a working computer
- checked in REGEDIT for {00020813-0000-0000-C000-000000000046} which shows 1.9 as the correct reference for my excel.
- I also wrote different codes to check if the AutoCAD reference has actually been found and added, the answer is yes (The references are always ticked after the error occurs).

Please find below the functions and references I use for the macro:
references used.png

Please Login or Register  to view this content.
I have been trying to figure this out for weeks now and looked everywhere I could but had no luck, I would be really appreciated if anyone could help me with this , thanks.

Cary