VBA in Office 97 + Welsh Characters

[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

 

[James Silverton]

Hello, MSK!
You wrote on Fri, 8 Dec 2006 04:08:01 -0800:

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

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

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

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

M> Can anyone help me here ?

It is a very long time since I used Office 97 seriously but I
believe the problem lies in the limited number of fonts in
"Insert Symbol". The circumflex characters on w and y only seem
to occur with the Tahoma and Lucida Console fonts. Even in
Office XP, tho Insert Symbol works for many fonts, I have to use
the hex code 0175+ALT-x to put w circumflex in directly. Tho
CTRL+^ e gives me e circumflex, MS does not seem to have thought
of w circumflex etc. Strange really since it did program y
dierisis!

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not