CODEWITHSUNDEEP
vb6office365
ninja_md
ninja_md

Reputation: 163

VB 6.0 run time error 429, ActiveX object can't create object after Office 2016 installation

I am trying to run a application build on VB 6.0 on machine with Office 2016. This application will be using Excel 16 which is throwing runtime error. The exact error is "Run time error '429': ActiveX component can't be created" even when i refer the Microsoft Excel 16.0 Object Library. The simple piece of code

Set xlapp = CreateObject("Excel.Application")

is throwing this error.

Operating System: Windows 7 64 Bit; Office version: 2016 32 Bit

Upvotes: 0

Views: 3026

Answers (2)

ninja_md
ninja_md

Reputation: 163

I have repaired Microsoft Office 2016 and then added the Microsoft Excel 16.0 Object Library to the VB code. It was able to create the object for excel class and also generated without any flaws :-) Thank you.

Upvotes: 0

Alex K.
Alex K.

Reputation: 175766

Your error is with rdoEnvironments which means you are using Remote Data Objects and that dependency is missing on the target machine.

RDO was a predecessor of ADO, to rectify the problem you need to try & locate a Remote Data Objects redistributable package from Microsoft, or try to create a deployment package on the development machine where the required DLLs are present and hope they get picked up.

Rewriting to ADO is worth considering if practical.

Upvotes: 2

Related Questions