Hello All,
I am using VBA script to perform few functionalities. Once of the functionality is not working and when checked in the Macro -> Tools -> References, one of the dll is wrongly mapped.
So I used command prompt and registered the dll using regsvr21 <name>.dll command.
Once I have done this, I am getting below error when I try to invoke the VBA script using a button.
System Error &H8007007E (-2147024770). The specified module could not be found.
I have tried repairing the office and also tried to change VBA from control panel.
Can anyone help in resolving this error.
Thanks.
I am using VBA script to perform few functionalities. Once of the functionality is not working and when checked in the Macro -> Tools -> References, one of the dll is wrongly mapped.
So I used command prompt and registered the dll using regsvr21 <name>.dll command.
Once I have done this, I am getting below error when I try to invoke the VBA script using a button.
System Error &H8007007E (-2147024770). The specified module could not be found.
I have tried repairing the office and also tried to change VBA from control panel.
Can anyone help in resolving this error.
Thanks.