question

Upvote
Accepted
JZ avatar image
22 ●3 ●3 ●2

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?

eikoneikon-com-apivba
icon clock
10 |1500

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

1 Answer

· Write an Answer
Upvotes
Accepted
Zhenya Kovalyov avatar image
4.6k ●26 ●7 ●22
icon clock
10 |1500

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

JZ avatar image JZ

Thank you very much sir!

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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