SQLBindVariable 
SQLBindVariableVolatile

SQL*XL
home

Syntax:
=sqlxl.xla!SQLBindVariable(Name)
= sqlxl.xla!SQLBindVariableVolatile(Name)

Name (datatype String): Name of the bind variable

Description:
The SQLBindVariable function displays the value of a bind variable. SQLXLBindVariableVolatile does exactly the same but this function will always be evaluated when Excel calculates.

Examples:
A1: =sqlxl.xla!SQLBindVariable("my_bindvar")

A1: abc
B1: =sqlxl.xla!SQLBindVariable(A1)

See also: