Macros generated with SQL*XL and Excel's macro recorder do not run and generate a runtime error on a statement
where a boolean value is used. This only occurs with non English versions of Excel. Boolean values in the macro
should be recorded in your language. In some cases you will find that SQL*XL statements are generated with the
English True and False as values.
Cause:
When Excel records the macro it uses True and False as values for boolean SQL*XL properties. When you run a
non English version of Excel, Excel's macro recorder changes the boolean values True and False to your language's
versions. In some cases it does not do this and the English True or False will generate an error when you try to
run the macro.
Some of the SQL*XL objects can only be resolved at runtime. SQLXL.Sql.Statements(1) is one of these. Statements(1)
can be any of a number of different objects. Therefore Excel cannot determine which type Statement(1)'s properties
are and will leave the boolean properties untranslated.
Resulution:
Simply replace the English True or False with the equivalents in your language.
Copyright (C) 1995-2007 Linker IT
Software BV. All Rights Reserved. Oracle is a registered trademark of
Oracle corporation. Excel and Office are registered trademarks of
Microsoft corporation. Other names appearing on the site may be trademarks
of their respective owners. Software,
files, documents, articles and other material are provided
"as is" and without warranties as to performance or mechantability or
any other warranties whether expressed or implied. No
warranty of fitness for a particular purpose is offered.
sitemap
