Thread: Discrepancy between Word and Excel syntax?

Edit: Cross-posted at http://www.mrexcel.com/forum/showthread.php?t=422923

Hi All,

I should disclaim that I'm quite novice at that, so my approach to writing macros is to record individual steps to determine the appropriate method, then copy and paste.

In any event, I have a macro that creates a word doc from content in an excel file. I copied over the code for inserting a text field from the Word Macro Recorder:

Code:

    Selection.FormFields.Add Range:=Selection.Range, Type:= _
        wdFieldFormTextInput

And pasted it (with msWord):

Code:

    With msWord
        .Selection.TypeParagraph
        .Selection.InsertDateTime DateTimeFormat:="M/d/yyyy", InsertAsField:=False, _
            DateLanguage:=wdEnglishUS, CalendarType:=wdCalendarWestern, _
            InsertAsFullWidth:=False
        .Selection.TypeParagraph
        .Selection.TypeParagraph
        .Selection.TypeText Text:="Dear "
        .Selection.FormFields.Add Range:=Selection.Range, Type:= _     wdFieldFormTextInput
        .Selection.TypeParagraph
End With

When I attempt to run this I get a "wrong number of arguments or invalid property assignment" error at the line that attempts to add the text field. Is this because of a discrepancy in syntax between Word and Excel, or am I making some other mistake?

Any help you can provide would be great. Thanks!

Thanks for including the link.......

Hello prawer,

It would be best if you posted your workbook so the all the code is available for review..