View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mike Fogleman Mike Fogleman is offline
external usenet poster
 
Posts: 1,092
Default How can I add Excel worksheet functions? (Financial)

That would be atpvbaen.xls
"Haldun Alay" wrote in message ...
Hi,

If you are trying to use an ATP function in you VBA project, you need to add Analysis ToolPak to your project from Tools|References in VBA editor.

Kind regards.

--
Haldun Alay
"eios" , haber iletisinde şunları ...

I believe I have done that. Tools = Add-in = Analysis Tool Pak right?

But still not working


Mike Fogleman Wrote:
The Analysis Tool Pak add-in must be installed. Do this from
Installation
Setup.
"eios" wrote in message
...

Hi,

I tried out application.worksheetfunction.xxx

but couldn't find the financial functions(add-in) like accrint,
duration. Could anyone tell me how I can gain access to the

financial
functions?

Thanks


--
eios

------------------------------------------------------------------------
eios's Profile:

http://www.excelforum.com/member.php...o&userid=15972
View this thread:

http://www.excelforum.com/showthread...hreadid=274477



--
eios
------------------------------------------------------------------------
eios's Profile: http://www.excelforum.com/member.php...o&userid=15972
View this thread: http://www.excelforum.com/showthread...hreadid=274477