SQLSubstitutionVariable 
SQLSubstitutionVariableVolatile

SQL*XL
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: