Insert Word field code using VBA from Excel

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?
 
M

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word Help! Word 2007 Macro Recording 0
creating a word table via vba 2
Controling Word from Excel 1
Importing Word text into Excel 12
How to Automatically Create Word Memos from Excel 1
Creating a Word Document from Excel Data 1
using vba to insert a table into word document 1
help with my code please. (Error: Object doesn't support this property or method) 5

Top