how to use INDIC LANGUAGE in VBA?

[appu_gusai]

hello ever 1,

this is my 1st post,

please tell me how to use Indic Gujarati Language in VBA with Excel 2003?

i m need to English Number to Gujarati Text formula, if any one have it give me, thank';s in advance

like 120=એક સો વીસ

thank's in advance

 

[appu_gusai]

How did you manage to use Gujarati characters in your Function because I get question marks only?

Biz

that's y m giving here, how to solve that?

 

[pgc01]

Hi

THe point in my post (post #6) was to explain how you can use your characters.

Maybe you should read it again, checking the options.

There are several options, I posted the code for one of them.

In your code replace

WORDs(1) = "એક "

with

WORDs(1) = ChrW(&HA8F) & ChrW(&HA95) & " "

and the same for the other words, using the Unicode codes that your can find for ex. in the link I posted.

Please try with 2 or 3 words to see that it works and then replace all.

Remark:

You should change the declaration:

Dim LENFIG As Integer

to

Dim FIGLEN As Integer

as that's the name of the variable you use later.

You should have at the beginning of the module

Option Explicit

THis would tell you immediately that there's this syntax error.

 

[appu_gusai]

Hi

THe point in my post (post #6) was to explain how you can use your characters.

Maybe you should read it again, checking the options.

There are several options, I posted the code for one of them.

In your code replace

WORDs(1) = "એક "

with

WORDs(1) = ChrW(&HA8F) & ChrW(&HA95) & " "

and the same for the other words, using the Unicode codes that your can find for ex. in the link I posted.

Please try with 2 or 3 words to see that it works and then replace all.

Remark:

You should change the declaration:

Dim LENFIG As Integer

to

Dim FIGLEN As Integer

as that's the name of the variable you use later.

You should have at the beginning of the module

Option Explicit

THis would tell you immediately that there's this syntax error.

thank's for this 90% done it, full code i will check later

thank's a million

 

[pgc01]

I'm glad it helped. Thanks for the feedback.

 

[Biz]

thank's for this 90% done it, full code i will check later

thank's a million

mate could you please post full code one it's working pls?
Biz

 

[appu_gusai]

I'm glad it helped. Thanks for the feedback.

i have done with full function , thank's a million for this SIR

lil more help SIR,
now 1 issue in this function

it's only for 200 hundred, when i type

200 = અંકે ૱પિયા બે સો પુરા
but m need 200 = અંકે ૱પિયા બ સો પુરા

 

[appu_gusai]

mate could you please post full code one it's working pls?
Biz

wait for some time, now m done it 99% 1 more issue then finished with GREAT HELP PGC01

last one issue finished, full code i post it here

thank's

 

[appu_gusai]

hello

and where can i fix it, please tell me

Option Explicit

 

[pgc01]

i have done with full function , thank's a million for this SIR

lil more help SIR,
now 1 issue in this function

it's only for 200 hundred, when i type

200 = અંકે ૱પિયા બે સો પુરા
but m need 200 = અંકે ૱પિયા બ સો પુરા

Hi

From what I understood in your laguage you have "dependent vowels" that can be combined with other characters.

The code for this sign follows immediately after the base character.

THe only difference I can see in the strings you posted is the characters બ and બે.

In this case try:

Range("A1").Value = ChrW(&HAAC)
Range("A2").Value = ChrW(&HAAC) & ChrW(&HAC7)

You'll see બ in A1 and બે in A2.

Since I don't know your language it's difficult to me to know which characters you have to combine to compose the characters.
I think you should study the "Gujarati Signs and Punctuations" section in the link I posted.

I hope this helps.

 

[appu_gusai]

Hi

From what I understood in your laguage you have "dependent vowels" that can be combined with other characters.

The code for this sign follows immediately after the base character.

THe only difference I can see in the strings you posted is the characters બ and બે.

In this case try:

Range("A1").Value = ChrW(&HAAC)
Range("A2").Value = ChrW(&HAAC) & ChrW(&HAC7)

You'll see બ in A1 and બે in A2.

Since I don't know your language it's difficult to me to know which characters you have to combine to compose the characters.
I think you should study the "Gujarati Signs and Punctuations" section in the link I posted.

I hope this helps.

hello SIR

this is right, but i need in that FUNCTION, when we type in A1 Cell 200, function call it અંકે ૱પિયા બે સો પુરા, but i need it in function અંકે ૱પિયા બ સો પુરા

how to code in that function , that is only for 200, all other value is set , when we type 200 function call for અંકે ૱પિયા બ સો પુરા

u just tell me how to code it, i managed my language

thank's a lot for this