Need Data type to declare a Variable

Hi,

I am creating a VBA Code, in which the output values have mulitple double quotes in it , like,

id (1) = create users "/" and/or "notify change"
id (2) = modify users "and"/"or"

I tried declaring the above values as String variables, however due to the presence of several double quotes, its throwing an error.

Kindly advice me on the correct data type to used for the above scenario

Hi,

Try one of the following. If you want a 'double quote' inside a string you have to double up (i.e. put 2 double quotes consecutively). Alternately you can use chr(34) which is the equivalent of ONE 'double quote'.

Please Login or Register  to view this content.

Lewis