Hi Seb,
The first issue you have is that, contrary to what you initially posted, your document has content controls, not formfields. That would account for the "5941: The requested member of the collection does not exist" message.
As your code also contains an 'End Sub' instead of 'Exit Sub' before 'ErrHandler:', I'm surprised it even got to the error handler.
As for the extraction itself, are you wanting to collect these data from a series of documents, or only from one document at a time? For collection from a series of documents, an Excel macro that automates Word would be preferable to one driven by a userform. After all, what happens if one runs the Export_Click twice, or not at all?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|