Availability of fonts in VBA

  • Thread starter Thread starter FrandeM
  • Start date Start date
F

FrandeM

I prepared a little VBA program under Excel to help myself and others i
the study of arabic. I created various "labels" which should sho
different arabic words using the font "Simplified Arabic" which i
available both in the Excel sheets and in the VBA editor; but that fon
is actually used only in the sheets, in VBA, when I launch the program
the "Tahoma" font is used instead, and that font is not good for m
purposes. Is there anyone who has an idea what could be the cause, an
possibly the solution, of the problem ?
Another thing: I'm facing this problem with Excel 2002 (SP2) but no
with Excel 2003, where everything goes smooth. Thank you so much
Francesco
 
I do think that font is installed because it appears in the lists o
fonts both under the Excel sheets and under VBA editor. Is there a wa
to check which fonts are actually available under VBA ? Could it b
that something was overlooked while installing the arabic language i
Office
 
Word has a FontNames object. To get the names in Excel, I had to link to the
Word object library, like this:

Set Wd = CreateObject("Word.Application")
Set FontList = Wd.FontNames

For Each FontName In FontList
'your code here to process the list
Next FontName
 
Thank you for your advice Myrna, I tried it and got the same list o
fonts that I get in the Excel sheets and in VBA editor, so th
"Simplified Arabic" seems to be actually available to VBA, but, as
matter of fact, for some reason it is replaced by "Tahoma" when th
program runs
 
Back
Top