userfuncExcelMacro
userfuncExcelMacro |
Purpose
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
Module