Excell Financial Analisis Functions from Access VBA
Posted on 2005-04-26
In Excell I have made use of the Yield function that resides in the financial Analisis add in.
When I remove the add in the worksheet still works but the function call now is changed to the following:
='C:\Program Files\Microsoft Office\OFFICE11\Library\Analysis\ATPVBAEN.XLA'!YIELD(A2,A3,A4,A5,A6,A7,A8)
In Access 97 I tried to make use of this Yield function in excell using the following code
Public Sub Tester()
Dim lDblYield As Double
Dim obj As Object
Set obj = CreateObject("Excel.Application")
lDblYield = obj.Yield(1, 2, 3, 4, 5, 6, 7)
Set obj = Nothing
But it breaks as It cant finds the function. Now how do I make Sure that the excell object I just instantiated recognises the Yield function that is available through the financial analisis add in?