Transferring Word to Excel -

[macropod]

It turns out that a change on 9/1 to the VBA in the Word document's template is causing the issue. I had added some code to manage the dropdown values of the last form field. When I attempted to import form data that predates the change there is no error.

Without seeing what specific changes you made, I really can't comment on their impact.

[Thyme2Cook]

Without seeing what specific changes you made, I really can't comment on their impact.

I'm chalking this one up to gremlins and since I now have a solution I'm good. Here's the code that I added to the Word template that I assume caused the issue in case anyone is interested. Restoring a previous version of the template that does not have this code resolved my issue.

Dim InAcRsn As String
 
'''''Manages "Inactive_Reason" dropdown.
 
With ActiveDocument.FormFields("Inactive_Reason").DropDown.ListEntries
    .Clear
    .Add "    "
    .Add "Deceased"
    …
End With
If InAcRsn = "" Then
    ActiveDocument.FormFields("Inactive_Reason").Result = "    "
Else
    ActiveDocument.FormFields("Inactive_Reason").Result = InAcRsn
End If

Till next time