Other Considerations When Writing Transportable Visual Basic Code

There are other things you need to consider when you're writing code that can vary by locale. The following are the most common of these considerations:

• Comparing strings

  The rules for comparing strings vary by locale when you're using the less-than (<), greater-than (>), equal-to (=), and Like operators, and the StrComp function. For more information, see "Option Compare," "Like," and "StrComp" in Help.

• Working with file input and output

  Locale is also a consideration for file input and output. The Print # statement writes to data into a file as the data is displayed on-screen in a locale-aware format. The Input # statement cannot read this information from the file. By comparison, the Write # statement puts data into a file in a fixed format, which ensures that the Input # statement can read it later in any user locale.

• Using the macro recorder

  The macro recorder records your actions in a module in the language specified on the Module General Tab, not in the language of the worksheet. If, for example, your language setting is English/United States and your locale setting (the setting for the worksheet) is French/France, the macro is recorded in English.

  You can use the FormulaLocal property to return a formula, as a string, in the same format in which it would be displayed in the formula bar (including the equal sign). For more information about the FormulaLocal property, see "Working with Formulas" earlier in this appendix.