Number of bytes in a string

[MaharajanM]

Hi Folks,

Itz a Q in VBA module.

How can i calculate total number of bytes in a string, when the string have 2 byte charactors and as well as single byte normal charactors?

Thx
Maharajan

 

[VBslammer]

How about something like this:

Function LenMbcs (ByVal str as String)
    LenMbcs = LenB(StrConv(str, vbFromUnicode))
End Function

VBSlammer

 

[MaharajanM]

Hi VBSlammer!

It works well. Thank you very much.

BTW, where can get info about compalte list of VB functions
like Split and StrConv

Thanks
Again

 

[VBslammer]

Using VBA Help Contents, go to:

[ul][li]-- Visual Basic Language Reference[/li]
[li]------ Functions[/li]
[li]---------- A-C[/li]
[li]---------- D-G[/li]
[li]---------- H-L[/li]
[li]---------- M-P[/li]
[li]---------- Q-Z[/li]


I also use the MSDN Library for more advanced topics.
VBSlammer