VBA in Office 97 + Welsh (UK) Characters issue

[MSK]

Hi,

I have designed some MS Word templates, these templates will have couple of
GUIs, and each GUI will contain lot of controls, some control will have the
details (name, city, department names..etc) in Welsh language, [one of the
regional language of UK - the special characters as follows (with Circumflex)
a,e,i,o,u,A,E,I,O,U,y,w,Y,W]

Users will select the required value and entered some values , these values
should be placed in the body of the word document then it will be printed for
the business need.

Everything is working fine in XP and Office 2003 environment but I am facing
some issue in NT + Office 97 environment.

The problem with Office 97 :-- These Welsh Characters are appearing
properly in the controls (combo box) but appearing as square box in the
document and printouts.

I have tried these implementation in two different way...
1. I have hard coded the values [name, city..etct] within VBA code

' // Addr(5).AddressInWelsh = "T" & ChrW$(Hex2Dec(Format(177, "0000"))) &
"’r Afon, Heol Bedwas# Bedwas"
'// Hex2Dec = CLng("&H" & HexVal)

2. I have a config file (UTF-8) formatted text file, which contains all
these values [name,city...etc]

Both scenario I am facing this issue in NT + Office 97

Can anyone help me here ?

Many Thanks

 

[Cindy M.]

Hi =?Utf-8?B?TVNL?=,

I suspect you're running into limitations of the rudimentary Unicode
implementation of Word 97 (the first version that even recognized Unicode
exists). Your best bet may be to look for the newsgroup where Klaus Linke posts
regularly (Google group search). He's the best source I know of for questions of
this nature, but I'm not sure which groups he's covering on a regular basis,
these days.

I have designed some MS Word templates, these templates will have couple of
GUIs, and each GUI will contain lot of controls, some control will have the
details (name, city, department names..etc) in Welsh language, [one of the
regional language of UK - the special characters as follows (with Circumflex)
a,e,i,o,u,A,E,I,O,U,y,w,Y,W]

Users will select the required value and entered some values , these values
should be placed in the body of the word document then it will be printed for
the business need.

Everything is working fine in XP and Office 2003 environment but I am facing
some issue in NT + Office 97 environment.

The problem with Office 97 :-- These Welsh Characters are appearing
properly in the controls (combo box) but appearing as square box in the
document and printouts.

I have tried these implementation in two different way...
1. I have hard coded the values [name, city..etct] within VBA code

' // Addr(5).AddressInWelsh = "T" & ChrW$(Hex2Dec(Format(177, "0000"))) &
"’r Afon, Heol Bedwas# Bedwas"
'// Hex2Dec = CLng("&H" & HexVal)

2. I have a config file (UTF-8) formatted text file, which contains all
these values [name,city...etc]

Both scenario I am facing this issue in NT + Office 97

Can anyone help me here ?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail