Run-time 429 error ActiveX component cant create object

%3CLINGO-SUB%20id%3D%22lingo-sub-1354547%22%20slang%3D%22en-US%22%3ERun-time%20429%20error%20ActiveX%20component%20cant%20create%20object%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1354547%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20order%20to%20address%20the%20problem%2C%20I've%20deleted%20the%2099%25%20of%20the%20codes%20from%20the%20project%2C%20but%20still%20getting%20the%20same%20weird%20problem%3A%26nbsp%3B%26nbsp%3BRun-time%20error%20429%3A%26nbsp%3BActiveX%20component%20cant%20create%20object%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECode%20a%20follows%3A%3C%2FP%3E%3CP%3EPrivate%20Sub%20Workbook_Open()%3CBR%20%2F%3EDim%20cName%20As%20String%3C%2FP%3E%3CP%3EEnd%20Sub%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1354547%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1354629%22%20slang%3D%22en-US%22%3ERe%3A%20Run-time%20429%20error%20ActiveX%20component%20cant%20create%20object%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1354629%22%20slang%3D%22en-US%22%3EBefore%20I've%20created%20personal.xlsb%20from%20the%20scratch%2C%20moved%20the%20project%20to%20a%20new%20xlsm%20file%20and%20get%20back%20again%20after%20the%20creation.%20Problem's%20been%20solved!%20FYI.%3CBR%20%2F%3E%3CBR%20%2F%3Ep.s.%20Thanks%20to%20everyone%20who%20has%20thought%20about%20the%20problem%2C%20though%20not%20solving%20it.%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

In order to address the problem, I've deleted the 99% of the codes from the project, but still getting the same weird problem:  Run-time error 429: ActiveX component cant create object

 

Code a follows:

Private Sub Workbook_Open()
Dim cName As String

End Sub

1 Reply
Highlighted
Before I've created personal.xlsb from the scratch, moved the project to a new xlsm file and get back again after the creation. Problem's been solved! FYI.

p.s. Thanks to everyone who has thought about the problem, though not solving it.