Initializing help system before first use

userfuncExcelMacro

userfuncExcelMacro

Purpose
Create a user function from a Microsoft Excel macro.
Synopsis
function userfuncExcelMacro(filename:string, sheetname:string, macro:string):userfunc
Arguments
filename 
Name of the Excel file including the function implementation
sheetname 
Name of the worksheet in the workbook including the Visual Basic macro
macro 
Name of the Visual Basic macro implementing the user function
Return value
A userfunc object that can be used in the F functions to be embedded in formulas.
Further information
User functions allow extremely complex, recursive or non-algebraic expressions to be included in nonlinear formulae. As such they may make use of simulators or other black box evaluators. The actual parameters to a user function depend upon the way it is bound to the model by the F function. Please see the chapter on user functions for more details. Communication with Excel carries significant overhead and performance degradation may result from using functions of this type.
Related topics
F, userfuncMosel, userfuncExcel, userfuncDLL.
Module
mmxnlp

Parent Topic Procedures and functions

© 2001-2019 Fair Isaac Corporation. All rights reserved. This documentation is the property of Fair Isaac Corporation (“FICO”). Receipt or possession of this documentation does not convey rights to disclose, reproduce, make derivative works, use, or allow others to use it except solely for internal evaluation purposes to determine whether to purchase a license to the software described in this documentation, or as otherwise set forth in a written software license agreement between you and FICO (or a FICO affiliate). Use of this documentation and the software described in it must conform strictly to the foregoing permitted uses, and no other use is permitted.