Extracting data from forms
Graham's reply provides an excellent method - especially if this is
something you need to do on a repetitive basis. Just on the off chance that
it may be a "one time thing" here's another option that might be useful but
less entailed since you don't have to deal with code.
In Word 2003 or prior Tools Options - Save provides a setting to Save Data
Only for Forms. In 2007 it's in Office Button Advanced Preserve Fidelity
when Sharing this Document - Save Form Data as Delimited Text File.
The resultant save can then be imported into Excel or Access.
Regards |:)
Bob Jones
[MVP] Office:Mac
On 6/7/08 5:58 PM, in article , "Mark
Lewis" wrote:
Is it possible to extract data from user entered fields into Access or
Excel?
Thanks
Mark
|