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


On Sat, 14 Aug 2004 18:08:46 -0500, FrandeM
wrote:

I do think that font is installed because it appears in the lists of
fonts both under the Excel sheets and under VBA editor. Is there a way
to check which fonts are actually available under VBA ? Could it be
that something was overlooked while installing the arabic language in
Office ?


---
Message posted from http://www.ExcelForum.com/