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!
1
●0 ●0 ●1
Hi, anyone familiar with execution error: DfaddPeriod method of "AdxDateModule" object failed? Thanks!
Hello
@mhon.cinco ,
It may be helpful to include Eikon Data API code excerpt that is resulting in this error on your side.
Thanks,
-AHS
hi @mhon.cinco ,
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text on the left side of the appropriate reply? This will guide all community members who have a similar question.
Thanks,
AHS
Hi,
Please be informed that a reply has been verified as correct in answering the question, and marked as such.
Thanks,
AHS
78.8k
●250 ●52 ●74
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
I hope this will help. If not, please share the code that you are using.
