export cell contents to Word fields in a protected Word document

The code below covers the basic requirement.

Set a reference to the Word 11.0 object library (Tools, References)

Sub Export_Data_To_Word_Form()
'set a reference to the Word 11.0 object library (Tools, References)
    Dim appWord As Word.Application
    Dim doc As Word.Document
    Dim strWordDoc As String
    
    strWordDoc = ThisWorkbook.Path & "\Report 01.doc"
    
    Set appWord = New Word.Application
    appWord.Visible = True
    Set doc = appWord.Documents.Open(strWordDoc)
    
    doc.FormFields("Field1").Result = ActiveSheet.Range("A2")
    doc.FormFields("Field2").Result = ActiveSheet.Range("B2")
    
    doc.Close True
    Set doc = Nothing
    appWord.Quit
    Set appWord = Nothing
End Sub

For document selection, look at the GetOpenFilename Method and the FileDialog object, both in VB help with examples.

Thanks T-J!

I will try that

Is there a way to export a cell on Excel 2010 to a field on Word?