How to do "Null:Blank" in Eikon API Dex2 ADC within the Excel VBA environment?

Question

Question by JZ · Jan 10, 2019 at 02:02 PM · vba dex2

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?

1

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2019-01-11T05:50:37Z

REFINITIV

Best Answer

Answer by Zhenya Kovalyov · Jan 11, 2019 at 05:50 AM

@de2de21c-65f0-44b8-bdc9-545b5dabedf8 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.

0 Show 1 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JZ · Jan 11, 2019 at 11:10 AM 0

Share

Thank you very much sir!

How to do "Null:Blank" in Eikon API Dex2 ADC within the Excel VBA environment?

1 Reply

Watch this question

Related Questions