VBA and Character data type

[Sorwen]

VBA doesn't have a character data type. VB does have a character data type. Is there a reference library (or something) I can add that will get me a character data type?

 

[JerryKlmns]

VB & VBA

Dim strX As String

 

[Sorwen]

That will not get me what I need (well "want" really since you can work without it).

Holds unsigned 16-bit (2-byte) code points ranging in value from 0 through 65535. Each code point, or character code, represents a single Unicode character.

That is what I need. Thanks though.

 

[PHV]

Have a look at the AscW and ChrW functions.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886