![]() |
|
#1
|
|||
|
|||
|
I need a Macro to list all the font name & its size in a word file - & list them
This is required as per the Audit by the Project Can the below Macro be fine tuned for the same. The Below Macro list all the fonts other than arial & give me the page number where the font is located in the 300 page document. I need to modify the macro to give me all the fonts & its size in the new macro Code:
Sub FindAllFonts()
Dim lWhichFont As Long
Dim sTempName As String
Dim sBuffer As String
Dim newDoc As Document Dim p As Long
Application.ScreenUpdating = False
For lWhichFont = 1 To FontNames.Count
sTempName = FontNames(lWhichFont)
If sTempName <> "Arial" Then
p = FindThisFont(sTempName)
If p > 0 Then sBuffer = sBuffer & sTempName & " on page " & p & vbCrLf
End If
End If
Next lWhichFont
Set newDoc = Documents.Add
Selection.TypeText Text:=sBuffer
Application.ScreenUpdating = True
End Sub
Function FindThisFont(sName As String) As Long
Selection.HomeKey Unit:=wdStory
With Selection.Find
.Text = ""
.ClearFormatting
.Font.Name = sName
.Forward = True
.Format = True
If .Execute Then FindThisFont = Selection.Information(wdActiveEndPageNumber)
End If
End With
End Function
Last edited by macropod; 01-29-2013 at 09:27 PM. Reason: Added code tags & formatting |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
how change size font to inches size
|
kkepo | Word | 4 | 08-28-2012 08:53 PM |
Size of image in Word document
|
no1texan | Drawing and Graphics | 1 | 06-29-2012 11:21 PM |
| Format Font Size in Combo Box List | lukewarmbeer | Word VBA | 0 | 08-27-2011 07:28 AM |
| Cursor size varies with font size | r_lewis@fuse.net | Word | 0 | 07-20-2011 06:11 PM |
Font list in Word 2007
|
rahl | Word | 2 | 06-26-2011 01:45 AM |