Hi tried to write a user-defined function which uses AdInterp function.
An error occurred when I tried to load the AdfinXanalystics module with the below code:
Set CreateAdxUtilityModule = CreateReutersObject("AdfinXAnalyticsFunctions.AdxUtilityModule")
The error message is "File not found: PLVbaApis.dll"
Please kindly help. Thanks!
I don't see anything wrong with your code, which is further evidenced by it having worked on another machine. So, the issue you experienced must be machine specific. Let's start with a quick sanity check. You do have Eikon installed on this machine, right? If you search in the Eikon install folder you can find PLVbaApis.dll file, correct?
Which version of Excel do you use? In particular I'm interested if it's 32-bit or 64-bit?