From: josh.projects on
Hello all,

According to the VBA documentation, the TextRange.Font object stores
several different font names (Font.Name, Font.NameAscii,
Font.NameFarEast, Font.NameComplexScript, Font.NameOther). Is there a
simple way to find out which one of those fonts is actually used to
display a given chunk of text?

I suppose it might be possible by checking the Unicode character range
manually (for example, if the text contains Chinese/Japanese/Korean
characters, the font specified by NameFarEast is used), but I'm not
sure when NameComplexScript and NameOther would be used.

Thanks in advance.
From: josh.projects on
Hmm... after some more experimentation, it seems that the actual font
used is in TextRange.Font.Name. Can anyone confirm?

On Jan 10, 12:27 pm, josh.proje...(a)gmail.com wrote:
> Hello all,
>
> According to the VBA documentation, the TextRange.Font object stores
> several different font names (Font.Name, Font.NameAscii,
> Font.NameFarEast, Font.NameComplexScript, Font.NameOther). Is there a
> simple way to find out which one of those fonts is actually used to
> display a given chunk of text?
>
> I suppose it might be possible by checking the Unicode character range
> manually (for example, if the text contains Chinese/Japanese/Korean
> characters, the font specified by NameFarEast is used), but I'm not
> sure when NameComplexScript and NameOther would be used.
>
> Thanks in advance.

From: John Wilson john AT technologytrish.co DOT on
That should give you the name of the font
--
Amazing PPT Hints, Tips and Tutorials

http://www.PPTAlchemy.co.uk
http://www.technologytrish.co.uk
email john AT technologytrish.co.uk


"josh.projects(a)gmail.com" wrote:

> Hmm... after some more experimentation, it seems that the actual font
> used is in TextRange.Font.Name. Can anyone confirm?
>
> On Jan 10, 12:27 pm, josh.proje...(a)gmail.com wrote:
> > Hello all,
> >
> > According to the VBA documentation, the TextRange.Font object stores
> > several different font names (Font.Name, Font.NameAscii,
> > Font.NameFarEast, Font.NameComplexScript, Font.NameOther). Is there a
> > simple way to find out which one of those fonts is actually used to
> > display a given chunk of text?
> >
> > I suppose it might be possible by checking the Unicode character range
> > manually (for example, if the text contains Chinese/Japanese/Korean
> > characters, the font specified by NameFarEast is used), but I'm not
> > sure when NameComplexScript and NameOther would be used.
> >
> > Thanks in advance.
>
>
From: josh.projects on
Got it, thanks very much. :)

On Jan 10, 5:16 pm, John Wilson <john AT technologytrish.co DOT uk>
wrote:
> That should give you the name of the font
> --
> Amazing PPT Hints, Tips and Tutorials
>
> http://www.PPTAlchemy.co.ukhttp://www.technologytrish.co.uk
> email john AT technologytrish.co.uk
>
> "josh.proje...(a)gmail.com" wrote:
> > Hmm... after some more experimentation, it seems that the actual font
> > used is in TextRange.Font.Name. Can anyone confirm?
>
> > On Jan 10, 12:27 pm, josh.proje...(a)gmail.com wrote:
> > > Hello all,
>
> > > According to the VBA documentation, the TextRange.Font object stores
> > > several different font names (Font.Name, Font.NameAscii,
> > > Font.NameFarEast, Font.NameComplexScript, Font.NameOther). Is there a
> > > simple way to find out which one of those fonts is actually used to
> > > display a given chunk of text?
>
> > > I suppose it might be possible by checking the Unicode character range
> > > manually (for example, if the text contains Chinese/Japanese/Korean
> > > characters, the font specified by NameFarEast is used), but I'm not
> > > sure when NameComplexScript and NameOther would be used.
>
> > > Thanks in advance.