callback in VBA relies on application.enableevents being set to true

jude.x.jin

Hello,

i just found out that the callback mechanism relies on application.enableevents being set to true in excel/vba.

that's why i'm asking you to provide me with an efficient synchronous query mechanism.

in sophisticated excel/vba tools, users often need to set the enableevents to false.

callback is very good in multithreaded(actor) languages like c#/java/scala... but not very convenient in excel/vba when users do need to do certain synchronous batch query.

Please provide me a good sample of how to efficient synchronous query in vba asap.

thank you very much,

jude jin

Alex Putkov.1

Hi @jude.x.jin,

I'm afraid you are mistaken. Please see my response to your comment on the original thread.

https://community.developers.refinitiv.com/questions/11185/how-can-i-use-the-comvba-api-in-batchnon-callback.html