Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling Analysis Add-in Funciton in VB
I wrote a macro which needs to call the yieldmat financial function fro
excel but for some reason it just doesn't seem to be recognizing it an I get an error. In general how do you call an add-in function from th vb environmen -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling Analysis Add-in Funciton in VB
Hi rvalente!
Set a reference to the Analysis toolpak add-in in the VBA Editor using Tools References. Check "atpvbaen.xls" If you don't see it in the list you need to go back to Excel and use: Tools Addins Check "Analysis ToolPak - VBA" Now back to the VBE and Tools References Check "atpvbaen.xls" After this you just use the functions in your VBA code -- Regards Norman Harker MVP (Excel) Sydney, Australia Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. "rvalente " wrote in message ... 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/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling Analysis Add-in Funciton in VB
thanks alot guys, it seems to be working, i appreciate it
-- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help with date funciton | Excel Worksheet Functions | |||
Excel 2002 Analysis ToolPak Regression Analysis Help Requested | Excel Worksheet Functions | |||
Analysis Toolpak-Confidence Level and data analysis questions | Excel Worksheet Functions | |||
RANK Funciton | Excel Worksheet Functions | |||
eomonth funciton in VBA | Excel Programming |