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!

 

[rlv01]

The error suggests a problem with an object or ActiveX control and likely means that your inherited macro requires an object or control (BLP_DATA_CTRLLib.BlpData) that is not installed on your PC. A random amount of googling also suggests that some people have seen macros using the Bloomberg Data Control developed under 2010 crash when ported to Excel 2016

 

[rd88817]

The error suggests a problem with an object or ActiveX control and likely means that your inherited macro requires an object or control (BLP_DATA_CTRLLib.BlpData) that is not installed on your PC. A random amount of googling also suggests that some people have seen macros using the Bloomberg Data Control developed under 2010 crash when ported to Excel 2016

yes, Bloomberg have updated their "Bloomberg Office Tools (32-bit)" on May 1st and I am having the same problem.
Will update when I have an answer...

 

[mena139]

wow! where did you see there was an update? been working on it for 15 hrs now!

 

[rd88817]

yes, Bloomberg have updated their "Bloomberg Office Tools (32-bit)" on May 1st and I am having the same problem.
Will update when I have an answer...

BLOOMBERG HELP DESK:
We have been sending out notifications in Excel since February, but there were some limitations in our ability to detect usage of the legacy APIs. This prevented some people from receiving notifications or receiving them late. We can keep the API enabled for an additional month. If you think you need more time than that, please contact your sales rep
ME: So it's an account setting on your side??13:01:11 BLOOMBERG HELP DESK : Yes, you have now been reverted. Please restart your computer to see the changes take place.

 

[rd88817]

looked under "Programs and Features"
installed on 5/1/2018 aka May,5 2018

 

[mena139]

and this worked for you?

 

[rd88817]

yes. I rebooted and it worked as it used to.
phew!

 

[mena139]

I can't believe that was it.

thank you so much!

 

[rd88817]

I can't believe that was it.

thank you so much!

Thank you! You helped confirm i was on the right track by posting this.
Did it solve it on your end too?

Keep in touch.
Richard
rd @ code .lu