How to select a font with a strange name?

[Konrad Viltersten]

I'm trying to use a font, the name of which is
EPSON kyoukashoM
but the problem is that "kyoukasho" is written in japanese
and that's not enterable in the editor. How can i specify
the name of the font then?

Alternatively - how can i choose ANY font, the name of
which starts with, let's say, "EPSO"?

P.S.
Sorry for not crossposting. My mistake...

--
Vänligen
Konrad
---------------------------------------------------

Sleep - thing used by ineffective people
as a substitute for coffee

Ambition - a poor excuse for not having
enough sence to be lazy
---------------------------------------------------

 

[NickHK]

Konrad,
All the Korean, Chinese and Japanese fonts that I use have a name in
English.
What name is shown for the font in your Fonts folder ?
Or in the Excel font combobox ?
A quick Google gives some entries for "EPSON kyokasho". Does that work ?

NickHK

 

[NickHK]

Konrad,
How does it appear in a Excel's font list ?
Are you using a Japanese system ?
What does it show if you use Character map ?

The file name or name that appears in the fonts folder is somewhat
irrelevant, as the name that you actually use as the font name is contained
within the file.

NickHK

 

[Konrad Viltersten]

Well, the name is as i mentioned "EPSON kyoukashoM" but
the kyoukasho-part is written in kanji. That's what shows in
the directory with all the fonts. I can't change that name,
it appears...

Konrad,
All the Korean, Chinese and Japanese fonts that I use have a name in
English.
What name is shown for the font in your Fonts folder ?
Or in the Excel font combobox ?
A quick Google gives some entries for "EPSON kyokasho". Does that
work ?

NickHK

--
Vänligen
Konrad
---------------------------------------------------

Sleep - thing used by ineffective people
as a substitute for coffee

Ambition - a poor excuse for not having
enough sence to be lazy
---------------------------------------------------

 

[NickHK]

Konrad,
Character map="%SystemRoot%\System32\charmap.exe"

I've never found a way to type non-ASCII text in the editor.
However, if the font name must be specified in the Japanese characters, you
can use ChrW and concatenate the string
Range("A1").Font.Name="EPSON " & ChrW(2052) & ChrW(2601)...whatever

Maybe that will work.

NickHK

 

[Konrad Viltersten]

Well, the name in the Excel's font list does contain kanjis
(as in - the real japanese chars, not only the yomi for them).
I'm on a swedish system with IME and support for JCK
activated. So, the way i understood , my computer can "see"
the 16-bit characters but the VBA-editor in Excel can't
use it...

What is Character map?

Konrad

Konrad,
How does it appear in a Excel's font list ?
Are you using a Japanese system ?
What does it show if you use Character map ?

The file name or name that appears in the fonts folder is somewhat
irrelevant, as the name that you actually use as the font name is
contained within the file.

NickHK

--
Vänligen
Konrad
---------------------------------------------------

Sleep - thing used by ineffective people
as a substitute for coffee

Ambition - a poor excuse for not having
enough sence to be lazy
---------------------------------------------------

 

[Konrad Viltersten]

This might actually be a good idea. Way out of what one should
have to cope with but workable. I'll try that right away. Thanks!

Konrad

Konrad,
Character map="%SystemRoot%\System32\charmap.exe"

I've never found a way to type non-ASCII text in the editor.
However, if the font name must be specified in the Japanese
characters, you can use ChrW and concatenate the string
Range("A1").Font.Name="EPSON " & ChrW(2052) & ChrW(2601)...whatever

Maybe that will work.

NickHK

--
Vänligen
Konrad
---------------------------------------------------

Sleep - thing used by ineffective people
as a substitute for coffee

Ambition - a poor excuse for not having
enough sence to be lazy
---------------------------------------------------