MS Word Forms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alex Andrenacci - 21 Oct 2003 15:36 GMT

I've created a form which is being completed by multiple
users. How could I combine the data from 200+ documents
so that I can analyse the information.

Reply to this Message

Charles Kenyon - 22 Oct 2003 01:38 GMT

Set them up to save only data. Word is not well suited for data analysis /
manipulation.
Excel?
Access?
a statistical package?

Signature

For more on online forms, check help and the links at <URL:
http://www.addbalance.com/word/wordwebresources.htm#Forms> especially Dian
Chapman's series of articles.

Hope this helps,
--

Charles Kenyon

Word New User FAQ & Web Directory:
<URL: http://addbalance.com/word/index.htm>

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide)
<URL: http://addbalance.com/usersguide/index.htm>

See also the MVP FAQ: <URL: http://www.mvps.org/word/> which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

> I've created a form which is being completed by multiple
> users. How could I combine the data from 200+ documents
> so that I can analyse the information.

Reply to this Message

Cindy M -WordMVP- - 27 Oct 2003 19:50 GMT

Hi Alex,

> I've created a form which is being completed by multiple
> users. How could I combine the data from 200+ documents
> so that I can analyse the information.

I take it these documents already exist? You can use VBA to
open them (put them all in a single folder then loop
through the folder's contents, for example), then go
through the form fields, read the information and write it
to the database.

I wrote an article about this a whle back. Unfortunately,
it's no longer available on-line. But it is on a CD that
can be ordered from the publisher. You'll find information
on my website, if you're interested.

Cindy Meister

Signature

INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail

:-)

Reply to this Message