Excel to Word with VBA - .font.size error

[Frankie Sharp]

Hello,
I'm new to VBA and am having trouble setting the size of a string that is being passed to a new word document using excel. I keep getting the error: Run-time error '5843': Method 'Size' of object '_Font' failed. I am using Office 2011.

Option Explicit


Sub CreateBasicWordReport()

    Dim wdApp As Word.Application

    Set wdApp = New Word.Application

    With wdApp
    
        .Visible = True 
        .Activate 
        .Documents.Add 
        
        With .Selection
            .ParagraphFormat.Alignment = wdAlignParagraphCenter
            .Font.Bold = True
            .Font.Size = 14
            .TypeText "Top Movies of 2012" 
            .Font.Bold = False
            .TypeParagraph
            .ParagraphFormat.Alignment = wdAlignParagraphLeft
            .TypeParagraph
            
        End With
        
    End With


End Sub

Help would be greatly appreciated!

 

[Damon Ostrander]

Hi Frankie,

I'm just guessing, but I suspect that to set the font size you must have some text (at least one character) selected. In your code above this doesn't appear to be the case.

Damon