View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Calling Analysis Add-in Funciton in VB

Hi
Set a reference to the Analysis toolpak, APTVBAEN.XLA and then simply
call the functions like
x = yieldmat(...)

--
Regards
Frank Kabel
Frankfurt, Germany

"rvalente " schrieb im
Newsbeitrag ...
I wrote a macro which needs to call the yieldmat financial function

from
excel but for some reason it just doesn't seem to be recognizing it

and
I get an error. In general how do you call an add-in function from

the
vb environment


---
Message posted from http://www.ExcelForum.com/