Loading Arabic data from an external text file into a ComboBox using VBA

[Mojtaba Ghasemi]

Hi,
I've Created a ComboBox in Word 2007 that loads some Arabic text from
an external text file.
It works but the problem is when i want to print it, it just breaks
the words and creates a whole messed up page.

I've tested three methods so far and all of them have the same bug.
Seems that the problem is with the language and encoding. I tried
everything that i could to fix it but the result is still the same.

has any of you tested that before ?
I can send the files or write the codes if it helps ?

thanks in advance

 

[dedawson]

I've run into this type problem before, and its more of a mess than
one might expect, involving code pages and associated languages.

The following link is to a thread in a different group. While it may
not solve your exact problem, it should give you some additional
insight into what you're up against.

http://groups.google.com/group/vbahelp/browse_thread/thread/4e37c2b326f53fbb#

 

[Mojtaba Ghasemi]

It seems finally someone understood what I'm saying,
thanks a lot "dedawson" for the link.

I'll try your method and check my file tomorrow because now is really
late here.

But would you do me a favor and check my files too like you did for
"tkapler"?
After all your the expert and you might see something that I don't.

 

[Mojtaba Ghasemi]

I checked the link you posted and tried the method but i couldn't get
any positive result from the first test.
I'm not even sure if I should convert the content to another unicode
because i don't have any problem in seeing the content, my problem
comes up when i want to print it.
I guess the problem shows up when vba comes in between otherwise
"Office Word" itself doesn't have any problem supporting Arabic
language, for example when i use the "Combo Box content control" it
works perfect but "Combo Box (ActiveX control)" that populates through
vba causes this mess.

The problem with the "Combo Box content control" is that you can't
populate it from an external file and also when i want to find an item
in it i should use the scroll bar to roll down and find it and it's
very unpleasant when you have a lot of items in it. you can't type the
first letter and expect it to go to the related items and you can't
move between the items with arrow keys on the keyboard.

These and some other reasons made me go for the combobox activex
control and now i'm stuck with this problem.

If you know something that i can followup just let me know.
thanks

 

[johndoe4024]

You may well be running into the same issue with the printer. What
fonts and character sets are resident on it? Could it be that they need
to be sent from the application? I don't know the answer, I'm just
conjecturing.

One other thing to consider. If I remember correctly, I had to do a
reboot before the language / code page associations I made actually
took. It seemed that while languages code could be changed as often as
one liked without a reboot, the associations got established at system
start and couldn't be changed on the fly.

Hope this helps; otherwise, I'm pretty well at a loss.