yearfrac problem

[Guest]

I have Excel 2002 in spanish. I created a system that calculates the interest
service from varios kind of debt from a Company. It requires to use the
yearfrac function to calculate how many days between each payment are to be
taken into account for the calculation of interest, given the diversity in
the types of bonds that this company issued.

The system requires to open for example 3 BIG!!! workbooks at the same time
(stock, cupons and proyected service) stock and cupon feed proyected service,
so they are linked. The function yearfrac is used in the workbook "cupons".

I have activated the add-ins required to use yearfrac. However when I open
the 3 workbooks I find that every place where I used the function yearfrac in
the woorkbook cupons the system substituted it for another name using the
path of the program ATPVBAEN.XLA , and aditionally it introduced the latter
as an external link!!!!! which I did no create.

After that the workbook "cupons" give me the error #Value where it is
suppose to calculate yearfrac!!!!.

Could somebody please help me and tell me how to correct it and why it
happen!!!!!

Thanks a lot!!!

Adriana

 

[Jerry W. Lewis]

YEARFRAC is a function in the Analysis ToolPak (ATP) and ATPVBAEN.XLA is
the VBA interface into the ATP. You say that you "have activated the
add-ins required to use yearfrac" are you by chance dealing with a name
collision between ATP and some custom add-ins?

Were the worksheets created on one computer and having this problem on
another?

Jerry

 

[Guest]

Dear Jerry:

No. I am just trying to use the function from the analysis toolpak, I did
not create any custom Add in.

The system that I designed was done on a computer witn Excel 2002 for
Windows XP in English and it runs well in it. However when it is running from
a computer in which the Excel is in a Spanish Version the problem appears
begining with the path where the function ATPVBAEN.XLA is located. While in
the english version this function was stored automatically in a carpet called
"Analysis" the spanish version have it in the carpet called "Análisis". When
I correct the path using edit/link the program runs well sometimes, but
always substitute the simple yearfrac function for the whole path including
the ATPVBAEN.XLA funtion, adding more caracteres to the whole instruction.

Thanks a lot for your help!!!!

Adriana