Creating Outlook object generates - Run-time error '429': ActiveX component can't create object

Question

I'm working on Excel-VBA code.

I'm getting run time error 429 on line -

Set mobjOLA = CreateObject("Outlook.Application")

Code is given below -

Public Sub Test
    Dim mobjOLA as Object
    Set mobjOLA = CreateObject("Outlook.Application")
End Sub

Are you trying to call the function from Excel as a custom formula? — Vityata
simply delete all your code between Function DeleteAppointmentItemBySubject and End Function, write this line and see whether it works. — Vityata

keerti keerti · Accepted Answer · 2018-06-01T07:49:17

There was mistake in system configuration. Reinstalling Office worked as a solution for me.