q Using a macro to paste data from Excel to Word

[David]

Does anyone know a good way to use a macro to paste data copied from an
Excel data table into a Word table. The data will always go to the same
location in Word. For example data copied from the Project Desc field in
Excel will always go to the Project Desc field in Word, data copied from the
Project Location field in Excel will always go to the Project Location field
in Word, etc..



I have advanced knowledge of using macros to move data around in Excel, but
know very little about how to place it into word.



Any help would be greatly appreciated.



David

 

[Cindy M -WordMVP-]

Hi David,

Does anyone know a good way to use a macro to paste data copied from an
Excel data table into a Word table. The data will always go to the same
location in Word. For example data copied from the Project Desc field in
Excel will always go to the Project Desc field in Word, data copied from the
Project Location field in Excel will always go to the Project Location field
in Word, etc..

Which version of Word?

What, more exactly, do you mean by a "field" as the target in Word. Word has
fields, but usually these are for displaying dynamic data. Do you mean a
bookmark? A form field? Something else?

When you paste, do you want just the text, or some table structure? Should
there a link?

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

 

[Peter Hewett]

Hi David

I posted the following in the previous thread, for continuity and so others can see what's
going on please use the original message thread:

<My second suggestion was not about copying data per se, but transferring the data a cell
at a time from an range in an Excel worksheet to a table in Word. This assumes that there
are the same number of rows and columns in the Excel range being copied and in the Word
table you are copying the data to.

Do you intend to push that data into Word from Excel, or pull the data Word from Excel?>

You did not reply to the above post.

Cheers - Peter

Does anyone know a good way to use a macro to paste data copied from an
Excel data table into a Word table. The data will always go to the same
location in Word. For example data copied from the Project Desc field in
Excel will always go to the Project Desc field in Word, data copied from the
Project Location field in Excel will always go to the Project Location field
in Word, etc..



I have advanced knowledge of using macros to move data around in Excel, but
know very little about how to place it into word.



Any help would be greatly appreciated.



David

HTH + Cheers - Peter