Adfin X Analytics 2.0 Function Library 16 Error String Property The Error String property of Adx Credit Module retrieves the last error code generated by the object.Syntax Error String() As String VBA sample Example Dim ct as Adx Credit Module Set ct = New Adx Credit Module ct.errormode = EXCEPTION On Error Go To Handle Res = ct.adcdsnpv("19sep02", "15SEP02", "5Y", 200, 0.3, [ratea].value, [credita].value, "RATETYPE: CMP CDSTYPE: AMERCDS CLDR: EMU_FI LFLOAT AOD: YES LFIXED FRQ:4 CCM: MMA0", "RISKMODEL: CURVE RECOVERY:0.3 NBDAYS:5 ND: DIS", "RM: YC ZCTYPE: DF IMCUBD") Exit Sub Handle Msg Box(ct. "Thomson Reuters" and the Thomson Reuters logo are trademarks of Thomson Reuters and its affiliated companies.
To start using VBA in Thomson Reuters Eikon Excel, you must perform the additional setup steps described below. DLL Note If they do not appear by default, browse to C:\Program Files (x86)\thomson Reuters\Eikon\X\Bin\ And use the following folder for DEX2: C:\Program Files (x86)\thomson Reuters\Eikon\X\Bin\Apps\TR. CORE\ \Bin\ VBA Programming in Thomson Reuters Eikon Excel 2 Working with Public APIs Introduction Public APIs allow you to access the data and functionality of Thomson Reuters Eikon from customized applications. To use them in Thomson Reuters Eikon, you must activate the optional Thomson Reuters Eikon Public API. Public APIs in Thomson Reuters Eikon Public APIs available in Thomson Reuters Eikon include: "Adfin X Analytics 2.0 Function Library" on page 5 "Adfin X Analytics 3.0 Object Library" on page 163 "Adfin X 6.0 Real-Time Library" on page 51 "DEX 2 Library (Data Engine Library)" on page 109 "Using RSearch COM API" on page 145 API Migration You can refer to these topics for more information on Public API migration: API Migration Using Adfin X-Analytics in Thomson Reuters Eikon Using Adfin X-Realtime in Thomson Reuters Eikon API Comparison Between Reuters 3000 Xtra and Thomson Reuters Eikon Working with Public APIs 3 Thomson Reuters API Usage in VBA "Adfin X Analytics 2.0 Function Library" on page 5 "Adfin X Analytics 3.0 Object Library" on page 163 "Adfin X 6.0 Real-Time Library" on page 51 "DEX 2 Library (Data Engine Library)" on page 109 "Using RSearch COM API" on page 145 Thomson Reuters API Usage in VBA 4 Adfin X Analytics 2.0 Function Library The Adfin X Analytics Function Library allows you to access Adfin function APIs. 3 Locate the file under the Bin folder of Thomson Reuters Eikon iby default, the folder is C:\Program Files (x86)\thomson Reuters\Eikon\X\Bin\ 4 Click Open.The function Ad Conv Calc Cpn returns an error Exits sub or function before the handle or code is executed Displays the Error String in a message box.In this case, the error string contains Error#7008 Set Structure with an unrecognized keyword.Syntax Error String() As String VBA sample Example Dim bd as Adx Bond Module Set bd = New Adx Bond Module bd.errormode = EXCEPTION Explanation Declares an object of variable the type Adx Bond Module Creates an Adx Bond Module object bd.errormode must be set to EXCEPTION to use the Error String On Error Go To Handle Error handler executes code after Handle when an error occurs RES = bd.bdsettle ("24-JAN-00", "GLT") Exit Sub Handle Msg Box (bd.errorstring) The style GLT does not exist.The function Bd Settle returns an error Exits sub or function before the handle or code is executed Displays the Error String in a message box.