Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I add Excel worksheet functions? (Financial)
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 fro 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 th 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 -- eio ----------------------------------------------------------------------- eios's Profile: http://www.excelforum.com/member.php...fo&userid=1597 View this thread: http://www.excelforum.com/showthread.php?threadid=27447 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I add Excel worksheet functions? (Financial)
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
financial functions | Excel Discussion (Misc queries) | |||
Financial functions in excel | Excel Worksheet Functions | |||
financial functions - HELP!!! | Excel Worksheet Functions | |||
Financial functions | Excel Worksheet Functions | |||
How can I add Excel worksheet functions? (Financial) | Excel Programming |