How to do "Null:Blank" in Eikon API Dex2 ADC within the Excel VBA environment?
I am trying to put in a parameter as "Null:Blank." This parameter works for =TR() formula on Excel interface. However, in VBA editor, when including "Null:Blank" as part of .RequestParam, the request class module will auto terminate itself when I execute the code. When putting it as .DisplayParam, VBA editor will pop-up an error window saying "Automation Error."
My ultimate goal is to replace NULL value with Blank in Eikon COM API Dex2. Any suggestions?
Find more posts tagged with
Sort by:
1 - 1 of
11
Sort by:
1 - 1 of
11
@jack_deprecated_0 It seems like the NULL parameter in the TR function is its own feature and is absent from the API. I am afraid, you will have to do the transformation manually.
@jack_deprecated_0 It seems like the NULL parameter in the TR function is its own feature and is absent from the API. I am afraid, you will have to do the transformation manually.
Thank you very much sir!