P
pcw
Are define names case sensitive when they are formatted to
Text?
My problem is that I created an Excel define name in the
following manner: "PostalCode" (uppercase for each word),
however, when a SQL server stored procedure was read into
Excel, the variable was (mistakenly) written
as "Postalcode (uppercase for the beginning of the word
only). As result, the stored procedure variable's value
never linked to its Excel "counterpart". The goal was to
link PostalCode with Postalcode.
I tried changing the format in Excel to General. But the
problem persisted. Based on this it would appear that the
define names in Excel were case sensitive.
Is this true? And how can I get around this?
Text?
My problem is that I created an Excel define name in the
following manner: "PostalCode" (uppercase for each word),
however, when a SQL server stored procedure was read into
Excel, the variable was (mistakenly) written
as "Postalcode (uppercase for the beginning of the word
only). As result, the stored procedure variable's value
never linked to its Excel "counterpart". The goal was to
link PostalCode with Postalcode.
I tried changing the format in Excel to General. But the
problem persisted. Based on this it would appear that the
define names in Excel were case sensitive.
Is this true? And how can I get around this?