Linker IT Software
Order Home
menubar-top-links menubar-top-rechts

SQL*XL: Database to Excel bridge

Related LIT software: litLIB: Excel power functions pack encOffice: Protect your Excel file easy and safe

Home Products SQL*XL Help Functions

Buy now

Download now

SQL*XL online help
 

SQL*XL: SQLSubstitutionVariable Excel function

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:

SQL*XL ribbon in Excel