Re: Unicode

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Jonathan West (jwest_at_mvps.org)
Date: 04/26/04


Date: Mon, 26 Apr 2004 10:53:38 +0100

Hi Raj,

When opening the file using the Open method of the Documents collection, you
should set the Format parameter to wdOpenFormatUnicodeText.

In order to ensure that the text displays correctly when you transfer it to
a UserForm, you will at least have to ensure that the relevant controls use
a font that supports all the necessary Unicode characters. Most fonts using
the Latin alphabet do not support all the non-latin characters.

The Arial Unicode MS font contains *all* the Unicode characters that have so
far been defined. If you do not have it already installed on your PC, there
are a number of locations on the internet from which you can download it.

Even this might not be sufficient, you will have to experiment. I'm not sure
that the controls in UserForms are fully Unicode-enabled. If they aren't,
then I think you will simply be stuck, unfortunately.

-- 
Regards
Jonathan West - Word MVP
http://www.multilinker.com
Please reply to the newsgroup
"Raj" <rra@who.dk> wrote in message
news:%23PeZBy2KEHA.1612@TK2MSFTNGP12.phx.gbl...
> Can anyone give me ideas on how to import Cyrillic text e.g. in Russian
> language from  .TXT file (Unicode format) to a Word document or a UserForm
> using VBA or VB6.
>
> Presently, I face the difficulty that the text appears as boxed characters
> in User form.
>
> Any help would be appreciated.
>
> Raj
>
>


Relevant Pages

  • Re: Unicode
    ... When opening the file using the Open method of the Documents collection, ... should set the Format parameter to wdOpenFormatUnicodeText. ... The Arial Unicode MS font contains *all* the Unicode characters that have so ...
    (microsoft.public.outlook.program_vba)
  • Re: Unicode
    ... When opening the file using the Open method of the Documents collection, ... should set the Format parameter to wdOpenFormatUnicodeText. ... The Arial Unicode MS font contains *all* the Unicode characters that have so ...
    (microsoft.public.word.vba.customization)
  • Re: Unicode
    ... When opening the file using the Open method of the Documents collection, ... should set the Format parameter to wdOpenFormatUnicodeText. ... The Arial Unicode MS font contains *all* the Unicode characters that have so ...
    (microsoft.public.word.vba.beginners)
  • Re: Unicode
    ... When opening the file using the Open method of the Documents collection, ... should set the Format parameter to wdOpenFormatUnicodeText. ... The Arial Unicode MS font contains *all* the Unicode characters that have so ...
    (microsoft.public.word.vba.userforms)
  • collations and Unicode string processing
    ... The collation of the databases and the default for the server is ... The short strings it appends might in some cases contain Unicode characters. ... all varchar datatypes for processing. ...
    (microsoft.public.sqlserver.programming)