question

Upvotes
1 0 0 0

Hi, anyone familiar with execution error: DfaddPeriod method of "AdxDateModule" object failed? Thanks!

Error is after upgrading to eikon 4.0.57. Still works on 4.0.53.
execution error: DfaddPeriod method of "AdxDateModule" object failed

Anyone familiar with this error? Thanks!

eikoneikon-data-apirefinitiv-dataplatform-eikonadfin
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

Upvotes
49.8k 124 44 62

@mhon.cinco

Sorry for the issue you are facing, let me see if I can help you in resolving this.

The version of my Eikon is 4.0.59. and I can run the code below properly.

Dim m_AdxDateModule As AdfinXAnalyticsFunctions.AdxDateModule
Private Declare PtrSafe Function CreateReutersObject Lib "PLVbaApis.dll" (ByVal progID As String) As Object
 
Sub Test()
    Dim res As Variant
    If m_AdxDateModule Is Nothing Then Set m_AdxDateModule = CreateReutersObject("AdfinXAnalyticsFunctions.AdxDateModule")
    res = m_AdxDateModule.DfAddPeriod("FRA", "12/02/2021", "1M", "EMC:S")
    Debug.Print res(1, 1) & ", " & res(1, 2)
End Sub

I used the following steps:

1. Create a new Excel file

2. Open Visual Basic in Excel

3. Import the PLVbaApis.bas file from the Eikon\Y\Bin (x64) folder

4. Add the AdXfo.dll from the Eikon\Y\Bin (x64) folder as references

5. Run the code

1663900000730.png

I hope this will help. If not, please share the code that you are using.


1663900000730.png (29.2 KiB)
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.