View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Barfbagger Barfbagger is offline
external usenet poster
 
Posts: 1
Default Insert Word field code using VBA from Excel

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?