Microsoft KB Archive/170229

From BetaArchive Wiki
Knowledge Base


Not All Arguments Are Auto-Capitalized in Visual Basic

Article ID: 170229

Article Last Modified on 10/11/2006



APPLIES TO

  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 95 Standard Edition
  • Microsoft Excel 5.0 Standard Edition



This article was previously published under Q170229

SYMPTOMS

When you type arguments into a Visual Basic for Applications macro, some of the arguments may not be capitalized automatically.

CAUSE

Visual Basic for Applications automatically capitalizes an argument that is recognized as an object, method, property, or type library name. For example, "Name" can be an argument and a property, so the "N" is capitalized. However, "savechanges" is an argument only, so the "s" and the "c" are not capitalized.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.


Additional query words: XL

Keywords: KB170229