Re: Word Form Fields - Can you Export to Excel Spread***?



Hi =?Utf-8?B?ZWxmbWFqZXN0eQ==?=,

I was able to then import that data into an excel spread***. Great, in
a
way. But here's the difficulty. I would have to do that with every
single
form I receive on an individual basis.

Yes, that's why I didn't even present the "Save as Text file 'solution'". Of
course, you could do that, and have macro code in Excel to run through all
the *.csv files in a folder, importing them one-by-one. If that would work
better for you (because people would be returning the text files), that's
fine - but you need to ask then in the excel.programming newsgroup.

THIS IS EXACTLY WHAT I NEED TO DO - post a form on a network location and
compile the data in Excel. What I can't find in Word's Help feature is
somewhere telling me how to do this!

Word/Office doesn't provide any way to actually bring the data into another
application for analysis. At some point, if you don't want to process each
form result manually, you have to delve into programming the solution (or
hire someone to do it for you).

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

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

.