Copy from drop down bo

[Geoff Atkinson]

Hi I'm using Word 2002. We have received a number of
questionnaire responses as Word docs, including several
drop down boxes with entries such as "2 - very
important". In view of the volume, we want to try to
automate the consolidation of the questionnaires as much
as possible - but when we copy a field from a drop down
box we cannot then paste the selected value into a
separate document.

Is there some way to do this? Ideally we would take the
data a whole column of 60 of these responses straight
into Excel, but copying to Word would be fine as a start.

Thanks in advance

Geoff

 

[Cindy M -WordMVP-]

Hi Geoff,

How about activating Tools/Options/Save, Save Data only for
forms, then saving? This will create delimited text files
you should be able to import directly into Excel. Much
faster than copy/paste...

Hi I'm using Word 2002. We have received a number of
questionnaire responses as Word docs, including several
drop down boxes with entries such as "2 - very
important". In view of the volume, we want to try to
automate the consolidation of the questionnaires as much
as possible - but when we copy a field from a drop down
box we cannot then paste the selected value into a
separate document.

Is there some way to do this? Ideally we would take the
data a whole column of 60 of these responses straight
into Excel, but copying to Word would be fine as a start.

Cindy Meister
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

 

[Geoff Atkinson]

Thanks Cindy much appreciated
Geoff

-----Original Message-----
Hi Geoff,

How about activating Tools/Options/Save, Save Data only for
forms, then saving? This will create delimited text files
you should be able to import directly into Excel. Much
faster than copy/paste...


Cindy Meister
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


.