Read all FormFields from a Word form into a VBA array

[approtech]

Hi,
My first post here so I hope this goes OK!

I am using VBA in Excel 2003 (Windows XP) to cycle through a set of Word files which are questionnaire returns using form fields. It all works fine, but I hoped to get a way to read all the elements of the FormFields() array in each Word document in one pass per document, to reduce the time taken (there are 118 form fields per document).

Currently I am using a loop for each Word file to read each result one at a time into my VBA array:

      For Qnum = 1 To HowMany
    Answers(Qnum - 1) = .FormFields(Qnum).Result
Next Qnum

Working on the basis that once the array is filled, I can return it to the spreadsheet in one pass with:

Range("A2").Resize(1, HowMany).Value = Answers()

what I wanted was something like:

Answers() = .FormFields().Result

However, that just gives the error:
Compile error: Method or data member not found

I've searched all the places I know and found nothing that helps.

Many thanks in advance,

Nic