UNICODE strings

[Petr Pavelka]

Hello,

I have an sheet with 3 columns (ID, english text, chinese text).

In a loop i go through all the rows and try to get english and chinese text
values using Str() fuction.

It works good with english text but not with thechinese one (it looks like
"????").

Any ideas ?

Thanks.

 

[Charles Williams]

try Cstr() rather than Str()


Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com

 

[Petr Pavelka]

Sorry, I am the beginner.

Shall I use something like:

CStr(Range("C3").Value)

This doesn't solve my problem. I need to get numeric (byte) representation
of the chinese string from cell 'C3'.

Thanks.

 

[Charles Williams]

Not sure what you are looking for: If what you want is the unicode numbers
corresponding to the unicode string then assign it to a byte array.

Dim arrBytes() As Byte

arrBytes=range("C3").value

This will give you two array elements for each character. the two array
elements contain the two Unicode bytes.


Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com