Merging certain cells from Excel to Word

[CMB]

I have someone that needs to be able to move certain cell
information from an Excel worksheet to a Word document.
When she tries to select the specific cells, for example,
she's prompted for the range from the data source, she
enters the number of each cell but it pulls ALL cell
information not just for the specific cells she requested.

Anyone have any ideas?

Thank you in advance.

 

[Cindy M -WordMVP-]

Hi Cmb,

I have someone that needs to be able to move certain cell
information from an Excel worksheet to a Word document.
When she tries to select the specific cells, for example,
she's prompted for the range from the data source, she
enters the number of each cell but it pulls ALL cell
information not just for the specific cells she requested.

She should open the workbook in Excel, select and copy the
cell(s) she needs, then paste into Word.

If she needs a link, then Edit/Paste Special, activate the
"link" checkbox and choose the format that works best for
the individual case.

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

 

[Guest]

Hi Cindy,

Thanks for responding. We were hoping to avoid doing the
cut and paste thing...we did find a way to concatenate
some fields to take one less step out of the process.

Thanks again. I appreciate the help.

Celeste

 

[Cindy M -WordMVP-]

We were hoping to avoid doing the

cut and paste thing...

Not CUT and paste; copy and paste. In my experience, that's
usually faster than going over an Insert menu, then
navigating to a document, etc.

If you really want to speed things up for the user, then
I'd go the route of a macro, where all she needs to do is
type in the range name she wants. The macro can then take
care of all the inserting part.

And I'd do that by creating a LINK field (same as
Edit/Paste Special).

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