View Single Post
 
Old 03-29-2017, 05:15 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote