Copy data from Word to Excel

[Jo]

I am trying to either copy or import data from a word
document which contains drop down boxes with entries such
as "2 - very important" into an Excel spreadsheet. Copy
& Paste doesn't work. I have also tried to save the word
document as a text document and then import. However,
even though I had selected the two Excel columns into
which I wanted the data imported, it was all imported
into row A1. Is there some way of specifying where
exactly this data is to be imported?

 

[Cindy M -WordMVP-]

Hi Jo,

I am trying to either copy or import data from a word
document which contains drop down boxes with entries such
as "2 - very important" into an Excel spreadsheet. Copy
& Paste doesn't work. I have also tried to save the word
document as a text document and then import. However,
even though I had selected the two Excel columns into
which I wanted the data imported, it was all imported
into row A1. Is there some way of specifying where
exactly this data is to be imported?

Did you try activating the option to save data only
(Tools/Options/Save) for the form, then save this (to a text
file)? And in Excel use the DATA menu to import it?

This will give only one row of data, because that's how data
records are normally organized. How are you imagining it
should be organized in Excel?

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