Just to expand on what rkc said, note that the Mid function can actually be
used on the left hand side of the = assignment, so it truly does give you all
the capabilities of an array of characters, both for reasing and for
assignment.
Of course, that's still nothing like what C# or Java have, but I don't think
it would be a good idea to add that kind of string to VB/VBA since it's so
very different from what we've all learned to expect from those languages. of
course, you could write your own String and Stringbuffer classes if you want
to. Someone might even have done it already and has it somewhere for
download.
On 2 Apr 2004 08:54:46 -0800,
me**************@msn.com (Johnny Meredith)
wrote:
Is there a function in VBA to convert a string to an array of characters. I'm
looking for the exact same functionality as the ToCharArray() method in C#.
If this functionality does not exist, do y'all have any pre-written code to
do this?
Psuedo-Hopeless Request-
Dear Microsoft: It would be cool if VBA had more robust string manipulation
functions like those in C#, which kick a*s.
TIA
Johnny