XL3RunSQL

Revision as of 11:47, 31 August 2011 by Csalter (talk | contribs) (Created page with "Allows a SQL Statement to be run when required (used in conjunction with XL3Link to trigger the execution) ==Syntax== {{Code|XL3RunSQL( [ExcecuteSQL], [ConnectionString], [...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Allows a SQL Statement to be run when required (used in conjunction with XL3Link to trigger the execution)

Syntax

XL3RunSQL( [ExcecuteSQL], [ConnectionString], [SQLStatement])

Parameters

Parameter Description
ExecuteSQL A cell reference that contains "TRUE" when the SQL Statement should be run
ConnectionString The connection string to use when running the writeback
SQLStatement The SQL statement to run

Examples

See Also