Insert Word field code using VBA from Excel

[Barfbagger]

I would like to export a variable number of chart pictures from Excel into a
Word document and give them a SEQ field number. Like so

With WordApp.Selection
.ParagraphFormat.Alignment = wdAlignParagraphCenter
.Paste
.TypeText Text:="Figure "
.Fields.Add Range:=Selection.Range, Type:=wdFieldEmpty, Text:="SEQ
FigNo \* Arabic" , PreserveFormatting:=True"
End With

However, I get a "Run-time error 438 : Object doesn't support this property
or method" message. Does this mean I can never insert a field code in Word
using VBA from Excel or is there another way to do it?

 

[macropod]

Hi Barfbagger,

Unless you're using early binding, you can't use Word constants like wdAlignParagraphCenter and wdFieldEmpty - you have to use their
numeric equivalents.