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 |
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 |
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 |
All times are GMT +1. The time now is 01:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com