Resolving Error Messages for Client Environments

The following table lists common errors and error messages and their possible resolutions.

Error Message Possible Resolution

Component not correctly registered

Reinstall Visual Basic 6.0 SP5: Run-Time Redistribution Pack found on the Microsoft download site.

ActiveX component not correctly registered (Error 336)

Reinstall Visual Basic 6.0 SP5: Run-Time Redistribution Pack found at the Microsoft downloads website.

Error Number: -2147024770 Description: Automation error. The specified module could not be found.

Perform the following steps:

  1. Open Windows Explorer.

  2. Navigate to c:\winnt\system32 directory and locate msxml6.dll.

  3. Right-click the DLL and select Register COM Server. The message DLLRegisterServer in c:\winnt\system32\msxml6.dll succeeded. will appear.

  4. Click OK.

Error Number: 429 Description: ActiveX component can't create object.

Perform the following steps:

  1. Open Windows Explorer.

  2. Navigate to c:\winnt\system32 directory and locate msxml4.dll.

  3. Right-click the DLL and select Register COM Server. The message DLLRegisterServer in c:\winnt\system32\msxml6.dll succeeded. will appear.

  4. Click OK.

Error Number -214722099 Description: Automation error in the dll.

Perform the following steps:

  1. Location and open the file ExcelToCI2007.xlsm.

  2. Press Alt + F11 to open the Microsoft Visual Basic Editor.

  3. Select Tools, and then Add references.

  4. Deselect anything that begins with Microsoft XML.

  5. Browse for c:\winnt\system32msxml6.dll and click OK.

  6. Select that version of msxml and click OK.

  7. Click Save.

Not Authorized (90,6)

The user who is trying to access the component interface from ExcelToCI does not have access to the component interface. Please provide access using PeopleTools Security.