Error in Loading DLL / Automation error - Library not registered

EXCEL Export || ActiveX Component can't create object 429, Error in Loading DLL or Automation error - Library not registered

At the time of excel sheet export issue occur → ActiveX Component can't create object 429, Error in Loading DLL or Automation error - Library not registered
      
      
      

Solution :

NOTE : This is not Software Related issue.

Usually error in loading dll Excel arise when due to the installation of any software the new DLL files overwrites the previously existing DLL file.
Apart from this, many DLL errors also occur due to the removal or corruption of the DLL files.
This at the end results in following DLL errors: “The DLL file is missing” or “The DLL file is not found” or “Error in Loading DLL” etc.

Regarding this issue, kindly initiate the repair process for the installed MS Office on your specific system by following these steps:
  1. Press the "Windows key + R".
  2. Type “Control panel” and press Enter.
  3. Navigate to Programs or Programs and Features (depending on your Windows version).
  4. Locate Microsoft Office in the list of programs.
  5. Right-click and select Change or Repair.
  6. Follow the on-screen instructions to complete the repair.
  7. Restart the System and then check with software.

If not Done, Please follow the Steps below:

1. Uninstall Complete MS Office in the system with the folders available in Program file / Program files(x86).
2. Remove registry keys created by the MSI installation of Office by deleting the registry keys - 

- Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office

            

- Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office

            

- Computer\HKEY_CLASSES_ROOT\TypeLib\{00020813-0000-0000-C000-000000000046}\------

            

3. Restart the system.
4. Now Install MS Office.

Now, start application and try again.

If same issue occur please contact your system engineer to get it resolved.