SQLSubstitutionVariable
|
home |
Syntax:
=sqlxl.xla!SQLSubstitutionVariable(Name)
=
sqlxl.xla!SQLSubstitutionVariableVolatile(Name)
Name (datatype String): Name of the bind variable
Description:
The
SQLSubstitutionVariable function displays the value of a substitution variable.
SQLXLSubstitutionVariableVolatile does exactly the same but this function will always be
evaluated when Excel calculates.
Examples:
A1: =sqlxl.xla!SQLSubstitutionVariable("my_bindvar")
A1: abc
B1: =sqlxl.xla!SQLSubstitutionVariable(A1)
See also: