Insert Word field code using VBA from Excel

  • Thread starter Thread starter Barfbagger
  • Start date Start date
B

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?
 
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.
 
Back
Top