Excel VBA based Error - "run-time error '-2147221231 (80040111)':

[mena139]

Every time I try to run the Macro that i have inherited from previous employees here, i get this new run time error.

run-time error '-2147221231 (80040111)':

automation error
ClassFactory Cannot supply requested class

when i hit debug it takes me to the following line

Dim objDataControl As BLP_DATA_CTRLLib.BlpData
Set objDataControl = New BlpData

and highlights the second. any advice on how to fix this or why this error is happening. yesterday this file wokred without issue and today I seem to be missing something.
any and all help is greatly appreciated.

Thanks in advance!

 

[mena139]

Ya solved my issue too! now i need to figure out how to correct the issue so we dont need to go through this again in a few weeks!!

 

[rd88817]

Ya solved my issue too! now i need to figure out how to correct the issue so we dont need to go through this again in a few weeks!!

yes. the best way, as far as i am concerned is to switch the part of the sheets that use BlpData to python. It is much simpler and a lot more reliable. obviously, it depends on the user interaction required.

 

[williamyk]

yes. the best way, as far as i am concerned is to switch the part of the sheets that use BlpData to python. It is much simpler and a lot more reliable. obviously, it depends on the user interaction required.

I have the same problem. Currently I am using VBA to call BlpData. If the legacy api cannot be used anymore, does switching to python can really help to solve?